I have used the formula:

="Old Price £ "&A1&""

Where A1 contains a currency amount. However as this will be cut and pasted elsewhere I also want it to have html tags around it so it should look like this:.


!!<<FONT COLOR="RED">Old Price £xx</FONT>!!

but I don't know where to put the html code in relation the formula (or even if i can)..

The A1 cell is formatted to currency to two decimal places but when it is used in the formula, it shows to 4 decimal places.

thanks