Changing a period by a coma on a number string.

[NERYONEIL]

Hello superior being (you know this answer and I don�t so you are superior than me by default
I have on A2 for example 5051.90.
I want to convert on B2 to 5051,90 (The period to convert to a coma).
How do I do it?

[AliGW]

Maybe:

=SUBSTITUTE(A2,".",",")

This assumes that A2 is text, not a number.

[NERYONEIL]

The only problem with that is that is not bringing me the last 0. Example of on A2 there is a 188.10 that formula brings me 188,1 and I need 188,10. Please advise

[AliGW]

It was a guess in the absence of a sample workbook from you ...

Please provide one.

[NERYONEIL]

Now is attached

[AliGW]

Thanks. Try this, please:

=SUBSTITUTE(TEXT(D2,"#.00"),".",",")

[NERYONEIL]

WOW IT WORKED! Thank you so much GENIO!

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

[NERYONEIL]

I try to marked Solve but I do not see the link or the drop down menu that gives me the choice, I try editing too, I can’t find the “solved” . I’m doing the post from my iPhone because I’m at work does that will be why I can’t find the “solve” choice?

[AliGW]

Oddly, it's not in the mobile version, but you can still do this:

You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Please don't quote posts when it's not necessary. Thanks.