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
Bookmarks