Keeping a zero as the first number in a cell

  • Thread starter Thread starter Turnipboy
  • Start date Start date
T

Turnipboy

This is probably a simple one but how do you keep a zero as the firs
number in cells with numbers, and also keep the cells' format as numbe
(I got it to work by changing the cell format to text but this was no
as elegant as I hoped)
 
You can do a custom format of "0"#
Rgds,
ScottO

"Turnipboy" <[email protected]>
wrote in message
|
| This is probably a simple one but how do you keep a zero as the
first
| number in cells with numbers, and also keep the cells' format as
number
| (I got it to work by changing the cell format to text but this was
not
| as elegant as I hoped).
|
|
| --
| Turnipboy
| -------------------------------------------------------------------
-----
| Turnipboy's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24527
| View this thread:
http://www.excelforum.com/showthread.php?threadid=477794
|
 
If you always want to see 5 digits with leading 0's, you could apply a custom
format of: 00000
 
Back
Top