zero "0" dropping from the beginning of my serial numbers

E

Elton Jones

How can I get my serial numbers that begin with "0" to not drop off the zero
in a cell of a spreadsheet?
 
D

David Biddulph

Format as text before you enter the data, or
Precede the data with an apostrophe to force it to be treated as text, or
Format as 000000 if you want to show 6 digits including leading zeroes.
 
M

Marcelo

format the cell as text

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Elton Jones" escreveu:
 

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

Adding recognised Zeros 5
Sort column beginning with blank? 1
Paragraph numbering in Word 1
Eliminating cells with a zero 7
Finding the right style field in VBA 0
Drop down list control value in vba 2
How can the font and size of (all) citation numbers be altered? 1
Unique Counting With Multiple Criteria 9

Top