How do you keep a 3-digit number starting with a "0" (ie. 058)

  • Thread starter Thread starter Guest
  • Start date Start date
How do you keep a 3-digit number starting with a "0" (ie. 058)?
Click to expand...

Several methods:

1. Enter it as TEXT: '058 (note the initial apostrophe).
2. Format/Cells/Number Custom Type: 000
3. =TEXT(A1,"000")
4. First format the cell as TEXT, then enter 058


--ron
 
If the numbers are actually TEXT and you don't intend to do any math on
them(like part numbers for instance), just format the cells for TEXT or use
a leading apostrophe when entering them.

Vaya con Dios,
Chuck, CABGx3
 
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

I want to generate 3 digit numbers out of 0 to 9 number 3
Special ID number 6
How add a digit to front of number in each cell in excexl column 1
Formatting Numbers to 3 digit, 3
16 digit number entry changes last digit to 0 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Custom Format on 16 Digit Number 5
Filter 3 digits 4

Back
Top