View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Why 5 becomes 0.05 and so on..

ToolsOptionsEdit and uncheck the fixed decimal box

--
HTH

Bob Phillips

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

"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