View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Why 5 becomes 0.05 and so on..

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"CENTROL BUSINESS" wrote in message
...
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