Thread: Converting string to number
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
No Name
 
Posts: n/a
Default Converting string to number
Thanks all of you, it's working now

Sorry try
=LEFT(A1, LEN(A1)-6)

Reply With QuoteReply With Quote