Cell format has suddenly changed in all new spread sheets
Just asking...
Did you see my reply
I ask because I want to check that my new server is propagating correctly.
It's not the first time that I've seen posts several hours after mine that
have *exactly* the same answer
hate to think my posts get through and are missed :)
Steve
On Sat, 28 Oct 2006 18:31:56 +0100, Gord Dibben <gorddibbATshawDOTca
wrote:
Andy
ToolsOptionsEdit.
Uncheck the option at "Fixed Decimal Places"
Gord Dibben MS Excel MVP
On Sat, 28 Oct 2006 01:17:02 -0700, Andy
wrote:
When I used to entre a number in my spread sheets as 120 it would read
120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now
1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please
|