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 |
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 |
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 |
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 | | | |
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 |
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 |
All times are GMT +1. The time now is 08:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com