J
Jason
How do you keep a 3-digit number starting with a "0" (ie. 058)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
Use a custom number format of 000.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
F
Frank Kabel
Hi
format the cell with the custom format
000
format the cell with the custom format
000
R
Ron Rosenfeld
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
C
CLR
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
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