How can I use 1 special character only inside a text?

Hey guys! Can you help me please with this issue?

I have a text, so i want "on text changed" to use 1 special character only. For example:

$29.99[/code:2oixky3j]
In this example i want to add only 1 "." character, I don't want to have this results:
[code:2oixky3j]$29..99
or
$29...........99
etc etc[/code:2oixky3j]
Can i? Thank you!!!

Hey guys! Can you help me please with this issue?

I have a text, so i want "on text changed" to use 1 special character only. For example:

$29.99[/code:dsrnugbx]
In this example i want to add only 1 "." character, I don't want to have this results:
[code:dsrnugbx]$29..99
or
$29...........99
etc etc[/code:dsrnugbx]
Can i? Thank you!!!

Not sure if this is what you are asking about, but you can combine text the way you want, that being numbers/text.

Nr1 = 29

Nr2 = 99

Text1.Text = "$" & Nr1 & "." & Nr2

Thank you for your reply. No i don't want to separate the text. I need 1 textbox to use it and write numbers (random). And when i hit "." character to add 1 time only.