Thread: Computers Excel Help
View Single Post
Old 07-10-2013, 08:00 AM   #6
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2076899
Quote:
Originally Posted by Iron Chef View Post
Thank you very much,

new wrinkle What if the start number is L00002001..The zeros at the front are falling off
Slight change in column B.

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

Change the number of zeroes in parenthesis to however many digits you need shown.
Posts: 51,739
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote