Number entered in cell getting always divided by 100 !

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
 
N

Niek Otten

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
 
G

Gyro

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
 
N

Niek Otten

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
| >
| >
| >
 
R

Rodrigo

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.
 
K

Kaneda

Hi Rodrigo,

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

That is it.
 
Top