I want to display the number 0 first in a cell, it won't let me n.

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

Guest

I want to be able to see a number with a zero in front of it as in 019, no
decimals or anything but everytime I enter it and move to the next cell the 0
automatically disappears. Can anyone help?
 
Lauren -

You'll have to format the cell as "Text" to make it work.

Hope this helps,

Carole O
 
Or, you can precede your value with a single quote...

'019

Hope this helps!
 
Right click on the cell, choose the "Number" tab. Within
the category field, choose text.
That should help
 
Lauren

In addition to the other posts.....

Enter 19 and Custom Format as 000.\

It will look like 019 but still be the number 19 if you need it for
calculations.


Gord Dibben Excel MVP
 
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

Displaying zeros in cells 2
How do I prevent the cell from changing the number I enter? 2
SUMIF or IF to display number of days or N/A 4
Custom number format #,##0.## yields extra '.' when formattingintegers 3
Want it show 0?? 7
Automaticallychanging the number of decimal places displayed 5
Cell displays #'s incorrectly 3
How do I format cells to show the number 0 as first number in seri 2

Back
Top