the formulabar will show significant digits only.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom wrote :

I'm having a problem with how my decimal places are displayed in the
"Formula Bar". I have the number of decimal places set to three for
all of the cells in my spreadsheet, but in certain instances, only one
or two places are all thats being displayed in the Formula Bar. An
example would be 0.500 (in the cell), but 0.5 is displayed in the
Formula Bar. Can someone please head me in the right direction?

Thanks,

Tom T.