how can i get a cell to hold a zero in front of a digit ie. 01 or.

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

Guest

I have tried checking the zero values box but still just takes the zero from
the front which I need for the table I am trying to plan. I don't want any
decimal points in front
 
You can do it three ways

1) If the 'number' you want to end up with is fixed length, say six
characters, then Format>Cells...>Custom>000000 will do it
2) Format the cells as text in advance of entry
3) Prefix with a single apostrophe ('). It will not show but will treat the
entry as text

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Use a custom numeric format like 00 or precede entry with an apostrophe or
format as text before you enter it

Regards,

Peo Sjoblom
 
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

How do I remove the apostrophe(') in front of zeros 3
How do I get excel to leave a zero in front of a number? 3
Adding 0 to the front of a number 4
how do I add a zero in front of a bunch of 4 digit numbers? 7
trying to insert a 0 in front of zipcode 2
I want to display numbers with zeros in front of them, eg 005 8
Leading Zero Dropped in Text Cell 3
Removing leading zero from cent amounts 2

Back
Top