Hello

I have a column of values (£) however excel doesn't recognise them as values and thus doesn't add them up. How do I convert them back to regular numbers so excel recognisers them?

Also - is there a formula I can use to add up the values for each month? So for example, January's Totals are=

Sample attached.

Many thanks
Ben

sample.xlsx