Forum Discussion
Solved
Dynamic hyperlink using cell data
Hello,
I'm trying to create an invoice/timesheet template that links directly to my paypal. The total invoice amount is in cell L3, and is derived from a formula adding all the hours and multi...
Hi Johnny
Give this workaround a try?
- 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.
- In the M cell (e.g. M3), type in the following formula =TEXT(L3,"#,##0.00").
- Make sure that your hyperlink formula =HYPERLINK("https://www.paypal.me/MyUserName/"&M3) refers to column M (the modified text formula cell).
- 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
Hi Johnny
Give this workaround a try?
- 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.
- In the M cell (e.g. M3), type in the following formula =TEXT(L3,"#,##0.00").
- Make sure that your hyperlink formula =HYPERLINK("https://www.paypal.me/MyUserName/"&M3) refers to column M (the modified text formula cell).
- 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
Thank you!
- Glad to help. If it was useful, please do mark it as your solution! Best of luck out there!