Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |