How to keep the zero on left without disappearing like 01234

G

Guest

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
 
B

Bryan Hessey

For a cell, the formula

=TEXT(A1+A2,"00000")

will allow a calculation and retain the leading zero.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addiing a Zero to a number which is already there 1
In Excel how can i enter in a value like 0021 without the zeros . 1
hiding zero for a sum 3
How to calculate the number of non-zero cells in range? 6
Display zero in the cells with Excel 2013 5
How do I get the zeros to show up in the beginning of a number? 6
how to display zero at the left hand of a code in a cell say 045 3
How do I retain a zero as the first number in a postal code? 7

Top