Excel 2000 losing decimal places on format.

  • Thread starter Thread starter Teggaman
  • Start date Start date
T

Teggaman

Hi,

this is probably very simple like an option that I've turned on, but I
have a problem when changing formats from general to 1(or any amount)
decimal place.

For example

General format - 0.79878787
After the following:-


Right click
format properties
Fixed , 1 decimal place.

or

cells(1,1).numberformat = "0.0"

I lose the remaining decimals and are left with just a rounded number
i.e. 0.8 , changing formats back or extending dec places has no
impact, and number stays at 0.8

Can you help

Thanks
Teg
 
Teg,

You using Tools - Options - Calculation - Precision as displayed?

Don't.
 
Back
Top