Thread: Converting string to number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
kenppy kenppy is offline
external usenet poster
  
Posts: 4
Default Converting string to number

This works but is still a string, how do I turn this to number?
thanks
says...
=LEFT(A1, LEN(A1)-5)

Will return your data as required as long as the text to be stripped is
constant

Reply With QuoteReply With Quote