| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My excel spread sheets are dividing all numbers input by 100.
There are no formula apparent and this occurs on all new worksheets and even
after reloading the software. The number 3 input appears as 0.03 and so on. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My excel spread sheets are dividing all numbers input by 100.
You have formatted the cells as percentage. Whatever you input will be
divided by 100. Change the format of the cells to other than percentage. RickM Prospector wrote: There are no formula apparent and this occurs on all new worksheets and even after reloading the software. The number 3 input appears as 0.03 and so on. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My excel spread sheets are dividing all numbers input by 100.
ToolsOptionsEdit.
Uncheck "fixed decimal places". Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 20:14:01 -0700, Prospector wrote: There are no formula apparent and this occurs on all new worksheets and even after reloading the software. The number 3 input appears as 0.03 and so on. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My excel spread sheets are dividing all numbers input by 100.
"RickM" wrote in message
oups.com... Prospector wrote: There are no formula apparent and this occurs on all new worksheets and even after reloading the software. The number 3 input appears as 0.03 and so on. You have formatted the cells as percentage. Whatever you input will be divided by 100. Change the format of the cells to other than percentage. I think you'll find that formatting as percentage will MULTIPLY by 100, not divide, Rick. Gord's suggestion (Fixed decimals) is the usual cause of these symptoms. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i cant find microsoft office or excel for spread sheets. i have wo | Setting up and Configuration of Excel | |||
| How do I change format of page numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
| Need to input data in excel that will print to pre printed sheets | Setting up and Configuration of Excel | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
