Prev: Financial Projections in Excel
Next: Filtered Mode Copying and pasting as value yield as error?
From: UNIFI on 15 Mar 2010 07:41
No longer when I open a new spreadsheet in Excel 2003 does my number format
defaults to general but with an odd formatting. When I enter a
number(example 8), the default format is 0.008. I cannot get the formatting
to change back so when I enter a number it looks like "8.0". suggestions?
From: Luke M on 15 Mar 2010 08:32
Goto Tools - Options - Edit, and uncheck the "Fixed decimals" box.

--
Best Regards,

Luke M
"UNIFI" <UNIFI(a)discussions.microsoft.com> wrote in message
news:223B7D5E-8668-4E6E-B7BC-9678AAA724B8(a)microsoft.com...
> No longer when I open a new spreadsheet in Excel 2003 does my number
> format
> defaults to general but with an odd formatting. When I enter a
> number(example 8), the default format is 0.008. I cannot get the
> formatting
> to change back so when I enter a number it looks like "8.0".
> suggestions?


From: Bernard Liengme on 15 Mar 2010 08:40
The problem is that you have set an option to give you three decimal places.
Some people set it to 2 so they can type 123 to get 1.23 (money)

Use Tools | Options , open the Edit tab and locate the Fixed Decimal box.
Make sure this is unchecked
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"UNIFI" <UNIFI(a)discussions.microsoft.com> wrote in message
news:223B7D5E-8668-4E6E-B7BC-9678AAA724B8(a)microsoft.com...
> No longer when I open a new spreadsheet in Excel 2003 does my number
> format
> defaults to general but with an odd formatting. When I enter a
> number(example 8), the default format is 0.008. I cannot get the
> formatting
> to change back so when I enter a number it looks like "8.0".
> suggestions?

 | 
Pages: 1
Prev: Financial Projections in Excel
Next: Filtered Mode Copying and pasting as value yield as error?