Excel automatically deviding 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
 
R

Ron Coderre

Try this:

From the Excel Main Menu:
<tools><options><edit tab>
UNcheck: Fixed Decimal Places

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 

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 dividing value by 100... 2
Excel Auto deviding numbers by 100 1
Excel automatically divides number by 100 3
Limit Decimal To Two In Text Field 3
How do I stop excel from changing single numbers like 1 into a de. 1
Number automatically divided by 100, why? 4
numeric entered automatically divided 100! 1
Need help: Excel automatically change input values 3

Top