convert string to number
I am extracting part of a string using Mid() and I need to convert this to
number format. Any ideas? |
convert string to number
Try one of these to convert the result of the MID function to a numeric
number. =--MID(........) =MID(........)+0 -- Biff Microsoft Excel MVP "Jeff Klein" <jklein@nospam wrote in message ... I am extracting part of a string using Mid() and I need to convert this to number format. Any ideas? |
convert string to number
Hi Jeff,
=VALUE(YourMidFormula) -- Kind regards, Niek Otten Microsoft MVP - Excel "Jeff Klein" <jklein@nospam wrote in message ... |I am extracting part of a string using Mid() and I need to convert this to | number format. Any ideas? | | |
convert string to number
=--MID(...)
will work as long as you parse out a number with the MID function -- Regards, Peo Sjoblom "Jeff Klein" <jklein@nospam wrote in message ... I am extracting part of a string using Mid() and I need to convert this to number format. Any ideas? |
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? |
All times are GMT +1. The time now is 07:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com