When inserting 007, Excel cuts out the two zero's.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make Excel leave the zero's at the beginning of the number?
 
Rio said:
How do I make Excel leave the zero's at the beginning of the number?
Click to expand...

Format the cell as TEXT or enter a leading apostrophe ( ' ) befor
keying in the numbers
 
You must either have the cell(s) formatted as text, which will hold the
actual characters in the cell. Otherwise, you can custom format the cell to
'000' which will display the leading zeros, but not hold them in the cell.

Hope this helps.
 
Change the format of the cell

=> Format Cells
=> Custom
typ in 000
and it works and it is still a number!!
 
You must log in or register to reply here.

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

Starting with a zero? 3
Displaying zeros in cells 2
2007 - automatically changes text data to numbers 2
How to stop Excel from automatically truncating leading zeros 2
how to show numbers that begin with 0 in excel 2
In Excel, when i key in 02352 and press enter, the zero goes off 1
Greater Than Symbols and calculations 0
How do I stop Excel from dropping leading zeros? 9

Back
Top