How to put £ sign before converted currency formula?

Hi There,

I have a formula in one of my cells that converts dollars to pounds -

However, I would like to put £ sign before the number in the formula.

Any help would be jolly well appreciated!



There are two primary ways of doing that with formula columns.

The first is to add a TEXT() function to the formula:

The second (usually preferred) is to set the format parameters of the column in the summary row. If you have turned off the summary for the column, you will need to turn it back on temporarily to set the parameters:

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you?
We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session

1 Like

Jim, much obliged! I had no idea about the second, option. Absolutely brilliant stuff.

Have a good weekend and thanks again.


1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.