Tony,
I presume that the £ and m indicate that you are dealing with text data,
not numeric data simply formated to show the £ and m.

If it is text data, and assuming your text, e.g. "£1.2m" is in cell A1,
put this formula in cell B1, or other cell.

=VALUE(LEFT(MID(A1,2,33),LEN(A1)-2))

Copy down to match your data in column A, and then add column B.




"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