Thread: How to change text into number?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default How to change text into number?
Or if the value is inside quotes then:

=MID(A1,2,LEN(A1)-2)*1

Just offering another possibility for consideration...

=--SUBSTITUTE(A1,"""","")

Rick
Reply With QuoteReply With Quote