Dynamic hyperlink using cell data

Hi Johnny

Give this workaround a try?

1. Create an empty column to the right of your dollar values (e.g. Your $ value is in L3, to the empty column should be M). Note you can hide this column later.
2. In the M cell (e.g. M3), type in the following formula =TEXT(L3,"#,##0.00").
3. Make sure that your hyperlink formula =HYPERLINK("https://www.paypal.me/MyUserName/"&M3) refers to column M (the modified text formula cell).
4. Your text in your hyperlink formula should now have a persistent two decimal places no matter what you two decimal placed value you enter in.

I've attached the sample file I have made on your scenario (and sample image below).

See the attached file for the full version

See if that helps?

Cheers

Damien