leading 0
 

Can someone tell me how I can get rid of the leading 0 in
a cell that should only show .30 instead of 0.30?
Probably a simple thing - but I jut can't find the answer.
thanks in advance for your help!
Cindy

FormatCellsNumber TabCustom.

enter .00 and OK your way out.


Gord Dibben Excel MVP



On Sat, 12 Mar 2005 19:15:08 -0800, "cb"
wrote:

Can someone tell me how I can get rid of the leading 0 in
a cell that should only show .30 instead of 0.30?
Probably a simple thing - but I jut can't find the answer.
thanks in advance for your help!
Cindy

Thank you!!!
Cindy

-----Original Message-----
FormatCellsNumber TabCustom.

enter .00 and OK your way out.


Gord Dibben Excel MVP



On Sat, 12 Mar 2005 19:15:08 -0800, "cb"

wrote:

Can someone tell me how I can get rid of the leading 0
in
a cell that should only show .30 instead of 0.30?
Probably a simple thing - but I jut can't find the
answer.
thanks in advance for your help!
Cindy

.