Transfer text to value

[slin]

Hi,

I want to use a formular to transfer 1.312,19 to value format like 1,312.19.

Can someone help?

Thanks!

[zbor]

here,

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1, ".", CHAR(135)), ",", "."), CHAR(135), ",")

[ChemistB]

Try this, if your original value is in A1
=VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,",","@"),".",","),"@","."))
Does that work for you?

[Ron Coderre]

Perhaps one of these approaches will help.

This formula converts the source text to a number, which can then be formatted any way you want:

Please Login or Register  to view this content.

This one creates numeric text in the format you describe:

Please Login or Register  to view this content.

Is that something you can work with?