View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Spreadsheet changing currency format

Goto Tools - Options - Edit, and uncheck the "Fixed decimals" box.

--
Best Regards,

Luke M
"UNIFI" wrote in message
...
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?