Hi Tony

In another column enter
=--SUBSTITUTE(SUBSTITUTE(C1,"£",""),"m","")
Copy down for the range of rows required.
If you want this to be a permanent change, copy the new range and Paste
SpecialValues back over the top of the old range.


Regards

Roger Govier


tony wrote:
Hi
I have a worksheet with column c recording values in the format of £1.5m ,
£2m etc but I need to sum this row is this possible ? or easy to convert ?
Thanks in advance Tony