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

Attached Files

example of uncovertable numbers.xlsx (9.9 KB, 11 views)