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