Thread: 1000 to 1 and 1 to 1000
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Olle Olle is offline
external usenet poster
  
Posts: 9
Default 1000 to 1 and 1 to 1000
When I type 1000 in one cell and then push enter, I would like that only 1 is
shown.

Vice versa, typing 1 €“ I would like the cell to show 1000.


Reply With QuoteReply With Quote