Only as text: if A1 has a value of 3.438,23 as number then this formula
returns 3,438.23 as text.

=SUBSTITUTE(LEFT(TEXT(A1,"#.##0,00"),LEN(TEXT(A1," #.##0,00"))-3),".",",")&"."&RIGHT(TEXT(A1,"#.##0,00"),2)

Regards,
Stefi

€žSimon€� ezt Ã*rta:

Hii all
I would like to display a result with EU punctuation and US punctuation in
the same sheet but in different coloumns. Ex.

EU: 3.438,23
US: 3,438.23

Is that possible?
When i try, it converts all data in to the same punctuation
I use excel 2003 european version

Thanks for any help