How to keep the zero on left without disappearing like 01234

[emcsquare]

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

 

[Pete_UK]

Format the cell as text beforehand.

Pete

 

[JMB]

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

 

[Bryan Hessey]

For a cell, the formula

=TEXT(A1+A2,"00000")

will allow a calculation and retain the leading zero.

--