Excel automatically dividing value by 100...

I

Irfan Khan

Whenever i am enetering any number in excel it is automatically deviding it
by 100 like if I enter 2 then it will store as 0.002. Whenever I am having
any formula calculation then there is no prblem .... Can anybody help me ???


Thanks a lot
 
T

Tim879

Another possibility is that you have custom formatting turned on for
that cell. Go to Format-> Cells and just click on the number format
 

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

Similar Threads

Excel automatically deviding value by 100... 1
Dividing - Negative Number by Zero 5
Excel automatically divides number by 100 3
How do I stop excel from changing single numbers like 1 into a de. 1
Why does 100 turn into 1 when I enter it into a cell? 3
Number automatically divided by 100, why? 4
How do I round up numbers when dividing? 2
numeric entered automatically divided 100! 1

Top