Thread: Excel Bar Code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Excel Bar Code

Format Cell, Choose Custom Format and enter the format as 0000000000000 (I am
assuming you need 13 digit numbers with leading zeroes). This will pad your
numbers with zeroes to give you a 13 digit number

"David" wrote:

Hi

I am entering bar codes in excel as 0900000901080, I need these to
automatically fill in in sequence and I am having problems with the 0 in
front, can anybody offer a solution?

Regards David