| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I change the default number format in excel?
Somehow, my excel settings were changed. Now, when I enter a number without
including a decimal, excel automatically adds one. For example, if I enter 1200 it shows as 12.00 instead of 1200. I want to enter numbers without using the decimal point. |
|
#2
|
|||
|
|||
|
chipster
ToolsOptionsEdit. Uncheck "fixed decimal places". Gord Dibben Excel MVP On Mon, 9 May 2005 14:02:14 -0700, "chipster" wrote: Somehow, my excel settings were changed. Now, when I enter a number without including a decimal, excel automatically adds one. For example, if I enter 1200 it shows as 12.00 instead of 1200. I want to enter numbers without using the decimal point. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel change number 1532 to 1235 running order | Excel Discussion (Misc queries) | |||
| how do i change the default number type which is formatted in new. | Excel Discussion (Misc queries) | |||
| EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) | |||
| how to change default comment format in excel (2000) | Excel Discussion (Misc queries) | |||
| Excel Number Format | Excel Discussion (Misc queries) | |||
Linear Mode
