How to keep the zero on left without disappearing like 01234
 

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

How to keep the zero on left without disappearing like 01234
 

Format the cell as text beforehand.

Pete

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

How to keep the zero on left without disappearing like 01234
 

For a cell, the formula

=TEXT(A1+A2,"00000")

will allow a calculation and retain the leading zero.

--

JMB Wrote:
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



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=529853