Thread: Report Numbers only
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
  
Posts: 70
Default Report Numbers only
A1 = 200C, I would like B1 to show the content of A1 with out the the letter
at the end. ie 200. I have tried to use INT, but that will only work on
decimal numbers.

Thanks
Reply With QuoteReply With Quote