Keeping a zero as the first number in a cell

[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)

 

[ScottO]

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
|

 

[Dave Peterson]

If you always want to see 5 digits with leading 0's, you could apply a custom
format of: 00000