|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 14th, 2009, 04:26 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
default format for Excel numbers
Whenever I enter numbers they display like they are divided by 100. I.E.
enter 256 and display = 2.56. I've checked the format cell, worksheet, etc but nothing seems to work. Somehow my Excel has changed its Default Formatting. How can I get it back to NORMAL? Thanks 
|
|
#2
June 14th, 2009, 06:11 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
default format for Excel numbers
Chuck G wrote:
Whenever I enter numbers they display like they are divided by 100. I.E. enter 256 and display = 2.56. I've checked the format cell, worksheet, etc but nothing seems to work. Somehow my Excel has changed its Default Formatting. How can I get it back to NORMAL? Thanks Assuming you're using Excel 2007, Click on the Office button -- Excel Options -- Advanced. Remove the check mark from the second item on the list - "Automatically insert a decimal Point".
|
|
#3
June 14th, 2009, 06:32 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
default format for Excel numbers
If 2003 or earlier................
ToolsOptionsEdit.....uncheck "fixed decimal places" This is a handy feature for Accountants but not for the rest of us. Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 20:26:01 -0700, Chuck G wrote: Whenever I enter numbers they display like they are divided by 100. I.E. enter 256 and display = 2.56. I've checked the format cell, worksheet, etc but nothing seems to work. Somehow my Excel has changed its Default Formatting. How can I get it back to NORMAL? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
