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

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

Use a custom number format of 000.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jason" wrote in message
...
How do you keep a 3-digit number starting with a "0" (ie. 058)?

Hi
format the cell with the custom format
000

--
Regards
Frank Kabel
Frankfurt, Germany

"Jason" schrieb im Newsbeitrag
...
How do you keep a 3-digit number starting with a "0" (ie. 058)?

On Sun, 5 Dec 2004 13:15:08 -0800, "Jason"
wrote:

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

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


"Jason" wrote in message
...
How do you keep a 3-digit number starting with a "0" (ie. 058)?