How do I keep the zeros...I need the numbe to be 0005...not 5?!?!

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

Guest

I have a catalog with product numbers that need to have the zeros infront of
the number...(ex 0244, 0017,0021) how do I set up my document to reflect that?
 
Hi Karla
Either put an apostrophe before the number
OR
Format the cell as text.
Formating as text works great, but remember that you won't be abe to use
maths on it if it is text.

HTH
Michael M
 
If there are always 4 digits you can use format>cells>number>custom and use
0000
otherwise precede entries with an apostrophe '
that way it is seen as text and the apostrophe is not visible in the cell
You can also preformat the cells as text but I would not recommend that in
case you pout a formula in one of those cells
since it would just return the text string


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 

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 add a zero infront of a number 10
Leading Zero 11
Displaying zeros in cells 2
How do I remove the apostrophe(') in front of zeros 3
how to display zero prefixes in worksheet cells such as phone numb 1
How to set the value? 6
Add Leading Zeros 4
Another Leading Zero Question 7

Back
Top