IFERROR returning text?

I cannot figure out why the calculation in D10 is not using my default WB decimal which is a comma, resulting in non number value.

Note: Because IFERROR is not supported in Excel for XP, a VBA UDF is used in module 1.

Hi drgkt,

Usually when a 'number' is automatically aligned to the left of cell, it is being treated as text by Excel.

Try wrapping your entire formula in =VALUE(). This will convert any number that is stored as text into a proper number.

Tried. it gives me 370394152046784,00

Besides, why the error only in D10?

Something wrong in the code in module 1?

Try this

=IFERROR(YOUR FORMULA)+0

Tried it before making this post, the result was 370394152046784,00.

Stormin' s post did the trick.

Thank you!