Thread: Report Numbers only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Hardeep_kanwar[_2_] Hardeep_kanwar[_2_] is offline
external usenet poster
  
Posts: 103
Default Report Numbers only
=Left(A1,3)

HARDEEP KANWAR

"The Rook" wrote:

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