Thread: help!! 1000 appears as 10 in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default help!! 1000 appears as 10 in excel
Tools|Options|Edit
Un-Check
Fixed decimal places

Mike

"Help!! 1000 appears as 10 in excel" wrote:

When I type 1000 it appears as 10. Can anyone help
Reply With QuoteReply With Quote