Reliable way to convert text to number with a formula
I am having issues converting numbers stored as text back to numbers.
Normally, the VALUE function should solve this, right?
Somehow it does not. I get an error when trying to convert "10.00" to a number using the VALUE function.
I attach a sheet to demo.
Just to pre-empt three things that won't work for me:
The scope of this file is such that it's not an option to manually convert the text to numbers using that error pop-up.
Unfortunately, I cannot fix the problem "upstream". My sheet will be receiving numbers stored as text.
Macros are also not an option. It must be a formula.
Does anyone know a solution.
Best regards
Pieka
|