Thread: Input numbers appearing incorrectly on spreadsheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Error in inputting numbers into excel Error in inputting numbers into excel is offline
external usenet poster
  
Posts: 1
Default Input numbers appearing incorrectly on spreadsheet
When I type a number into excel the number appearing in the cell is divided
by 100.
i.e. if I input 1 the number in the cell is 0.01
but if I input 1.0 the number is correctly displayed as 1

Any ideas, it driving me to drink
Reply With QuoteReply With Quote