| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Number entered in cell getting always divided by 100 !
I use excel 2007. Whenever i enter a number in cell, it gets divided by 100.
For example, when i enter 10, it displays as 0.01. How to resolve this problem ? really frustrated with this error ! DKL |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Number entered in cell getting always divided by 100 !
Office button (large, round, top left corner)Excel OptionsAdvanced tab, uncheck Automatically insert a decimal point
-- Kind regards, Niek Otten Microsoft MVP - Excel "Dipen" wrote in message ... |I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. | For example, when i enter 10, it displays as 0.01. | | How to resolve this problem ? really frustrated with this error ! | DKL |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Number entered in cell getting always divided by 100 !
I am using Excel 2003 with same problem. There is no Office button. How do
I get the entries not to be divided by ten? Joe G "Niek Otten" wrote: Office button (large, round, top left corner)Excel OptionsAdvanced tab, uncheck Automatically insert a decimal point -- Kind regards, Niek Otten Microsoft MVP - Excel "Dipen" wrote in message ... |I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. | For example, when i enter 10, it displays as 0.01. | | How to resolve this problem ? really frustrated with this error ! | DKL |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Number entered in cell getting always divided by 100 !
ToolsOptionsEdit tab, uncheck Fixed decimal
-- Kind regards, Niek Otten Microsoft MVP - Excel "Gyro" wrote in message ... |I am using Excel 2003 with same problem. There is no Office button. How do | I get the entries not to be divided by ten? | Joe G | | "Niek Otten" wrote: | | Office button (large, round, top left corner)Excel OptionsAdvanced tab, uncheck Automatically insert a decimal point | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Dipen" wrote in message ... | |I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. | | For example, when i enter 10, it displays as 0.01. | | | | How to resolve this problem ? really frustrated with this error ! | | DKL | | | |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Number entered in cell getting always divided by 100 !
Hi Niek,
Please help me in Office 2008 for Mac. There is the same problem, all numbers are divide by 100. But in the Mac the menu is different like in Windows. Can you help me? Thanks. "Niek Otten" wrote: Office button (large, round, top left corner)Excel OptionsAdvanced tab, uncheck Automatically insert a decimal point -- Kind regards, Niek Otten Microsoft MVP - Excel "Dipen" wrote in message ... |I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. | For example, when i enter 10, it displays as 0.01. | | How to resolve this problem ? really frustrated with this error ! | DKL |
|
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Number entered in cell getting always divided by 100 !
Hi Rodrigo,
Preferences - Edit - Uncheck Display this number of decimal places. That is it. "Rodrigo" wrote: Hi Niek, Please help me in Office 2008 for Mac. There is the same problem, all numbers are divide by 100. But in the Mac the menu is different like in Windows. Can you help me? Thanks. "Niek Otten" wrote: Office button (large, round, top left corner)Excel OptionsAdvanced tab, uncheck Automatically insert a decimal point -- Kind regards, Niek Otten Microsoft MVP - Excel "Dipen" wrote in message ... |I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. | For example, when i enter 10, it displays as 0.01. | | How to resolve this problem ? really frustrated with this error ! | DKL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numeric entered automatically divided 100! | Excel Discussion (Misc queries) | |||
| Number entered isn't number recorded in cell. | Excel Discussion (Misc queries) | |||
| All number inputs are divided by 100 ? | Setting up and Configuration of Excel | |||
| All Numbers entered divided by 100,000,000,000! | Excel Discussion (Misc queries) | |||
| in excel why do numbers entered get divided by 100? | Excel Discussion (Misc queries) | |||
Linear Mode
