Thread: text to numeric
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] luistotonho65@gmail.com is offline
external usenet poster
  
Posts: 3
Default text to numeric
Hi,

I have the following text: "34.00 - 39.50". Is there a way to convert
them into numerics format? Ex: 34.00 in B1 and 39.50 in C1, without
typing?

Thanks
Reply With QuoteReply With Quote