View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMB
 
Posts: n/a
Default How to keep the zero on left without disappearing like 01234

Would a custom number format work for you?
Format/Cells/Custom 0000000




"emcsquare" wrote:

How to keep the zero on left without disappearing like 0123454
In scanning software requires us to use excel .but in excel every time I
scan a barcode with a zero in the beginning it disappear automatically