Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet changing currency format
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet changing currency format
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" 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Format Currency without changing values - over 16,0000 row | Excel Discussion (Misc queries) | |||
Changing cell format from text to currency | Excel Worksheet Functions | |||
How do I format spreadsheet w/o changing font size? | Excel Worksheet Functions | |||
Can I insert excel spreadsheet in word and keep currency format? | Excel Discussion (Misc queries) | |||
Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) |