I also would like to request a function that formats to currency. I have a column that the formula pulls a day of the week and an amount earned in to one entry, and because there is now text in the solution, the formatting loses the currency symbol a...

I really need this as well! The ability to add a hyperlink instead of the full link address would make this way easier for my staff to read, especially since some of them are so long and it looks terrible.