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

  • Thread starter Thread starter Elton Jones
  • Start date Start date
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?
 
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.
 
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

How to count the maximum number flanked by zeros 9
Displaying zeros in cells 2
Adding recognised Zeros 5
Sort column beginning with blank? 1
Eliminating cells with a zero 7
Two Criteria COUNTIF 7
How to keep zeros at the begining of a number 2
Unique Counting With Multiple Criteria 8

Back
Top