|Subject:||Excel 2000 losing decimal places on format.|
|Posted by:||Teggaman (gregnowliv…@yahoo.co.uk)|
|Date:||2 Oct 2003|
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)
General format - 0.79878787
After the following:-
Fixed , 1 decimal place.
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