Why 5 becomes 0.05 and so on..

C

CENTROL BUSINESS

I am defeated. Don't know what happened. Every number I key in become
'divide by 100' ie 5 becomes 0.05, 300 becomes 3, 6000 becomes 60.....

Plse help.



Email Signature Powered by NameCardOnline.com -- Exchange | View | vCard
 
B

Bob Phillips

Tools>Options>Edit and uncheck the fixed decimal box

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bernard Liengme

Excel has a feature to allow lazy people to enter numbers without the
decimal and have Excel insert it. To switch this off: Tools | Options; open
Edit tab; deselect the Fixed Decimal box.
beat wishes
 
S

Scafidel

CENTROL BUSINESS said:
I am defeated. Don't know what happened. Every number I key in become
'divide by 100' ie 5 becomes 0.05, 300 becomes 3, 6000 becomes 60.....

Plse help.
Click to expand...
I set up a new spreadsheet Friday and wanted 5 decimal points and changed
the setting at Tools, Options and forgot about it. Today I had the same
problem Centrol has. It wasn't until I came here and found this that I
remembered what I had done to cause me to have the same problems. Thanks for
this group! Jerry
 
D

Dave Peterson

Tools|Options|Edit tab|uncheck Fixed decimal
I set up a new spreadsheet Friday and wanted 5 decimal points and changed
the setting at Tools, Options and forgot about it. Today I had the same
problem Centrol has. It wasn't until I came here and found this that I
remembered what I had done to cause me to have the same problems. Thanks for
this group! Jerry
Click to expand...
 
Top