Thread: convert string to number
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default convert string to number
Just multiply it by 1 (or add zero) as part of your formula:

=1*MID(A1,3,2)

Hope this helps.

Pete

On Nov 1, 9:44 pm, "Jeff Klein" <jklein@nospam wrote:
I am extracting part of a string using Mid() and I need to convert this to
number format. Any ideas?


Reply With QuoteReply With Quote