Value trouble!!!

S

Sim

Hello all,
Whenever I am adding any value to a cell, the value by itself gets divided
by 100, that means if I am writing 1000, it shows the value of 10!!! And if I
type 1000.0, then it shows the value 1000, I have checked the decimal points
and everything seems to be ok!!! So, if I type 1234, it shows 12.34!!! Please
help!!!
 
B

Bob Phillips

Goto Tools>Options and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Spread values across fields 1
Extracting Data From The Right of a Cell 1
Date Time decimal value help please 1
Excel Countif Function - Calculating Between Two Sets of Values 3
Summing up values 5
Style Header Reformatted 3
Earned value (BCWP) showing as zero in chart 0
Percentage tolerance with break points. 1

Top