How to format currency

I have a possibly related question. I have repeat region in a table with a numeric column that retrieves numeric data from the database. I have used the format option to convert this to currency. However it shows as $ and my site is UK so would require £. Is there an easy way to apply this or is it a server issue?

You can enter your currency symbol in the unit field of the currency format options:

Thanks Theodore. Still learning but getting there now!