Thread: leading 0
View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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