Check if the number have two decimal point

[darkhangelsk]

Good day guys! I have a problem with the values contains two decimal point:

sample:

a1 -> 2.333.33 "i want this to return as 2,333.33"

a2 -> 33.33 "i want this to retun 33.33"

a3 -> 45.555.55 "i want this to return 45,555.55"

i already asked this question and someone gave me this code -> substitute(a1,".","",1) which return to 2333.33 but the problem is for the a2 if i use the code it will return as "3333" which read as "3,333". Is there any way that we can determine if the values have two decimal point before it will run the command?

Thanks!

[ChemistB]

This equation should work

Please Login or Register  to view this content.

It also converts your string to a number so you can format it properly (e.g. with a comma or not) Does this work for you?

[NBVC]

Try

=IF(ISNUMBER(A1),A1,SUBSTITUTE(A1,".","",1)+0)

[darkhangelsk]

yey! I think they're both working. Thanks for your help