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
 
Ad

Advertisements

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

Advertisements

K

Kaneda

Hi Rodrigo,

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

That is it.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top