DECIMAL PLACES DISPLAYED
 

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.

DECIMAL PLACES DISPLAYED
 

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.

DECIMAL PLACES DISPLAYED
 

The formula bar doesn't append zeros to the end of a value. Since 0.5
defines the value stored in the cell, that is what it displays. It doesn't
observe how you have formatted the cell.

if the number were entered as

3.12345

it would appear in the cell as

3.123

but the formula bar would show you what is actually stored in the cell:
3.12345

--
Regards,
Tom Ogilvy

"Tom" wrote in message
om...
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.