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
Bookmarks