Excel 2000 losing decimal places on format.

Giganews Newsgroups
Subject: Excel 2000 losing decimal places on format.
Posted by:  Teggaman (gregnowliv…@yahoo.co.uk)
Date: 2 Oct 2003

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

Replies