Number entered in cell getting always divided by 100 !

  • Thread starter Thread starter Dipen
  • Start date Start date
D

Dipen

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
 
Office button (large, round, top left corner)>Excel Options>Advanced tab, uncheck Automatically insert a decimal point

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
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
 
Tools>Options>Edit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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 Options>Advanced tab, uncheck Automatically insert a decimal point
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |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
| >
| >
| >
 
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.
 
Hi Rodrigo,

Preferences -> Edit -> Uncheck Display this number of decimal places.

That is it.
 
Back
Top