Thread: Computers Excel Help
View Single Post
Old 07-10-2013, 08:10 AM   #8
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 

Join Date: Aug 2000
Location: Georgia
Casino cash: $7644981
Quote:
Originally Posted by DaFace View Post
Slight change in column B.

="L"&TEXT(A1,"00000000")

Change the number of zeroes in parenthesis to however many digits you need shown.
Thank you very much...Worked like a charm.
Posts: 418
Iron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking about
     Reply With Quote