Hi, I have been sent an excel spreadsheet which has a column of numbers which I need to SUM. When I enter the SUM it returns a 0. I've tried copying and formatting, multiplying by 1, adding 0, find and replacing . with ,; find and replace " " with nothing but no matter what I do, it still returns the sum of 0.
Please can someone offer any other advice?
Many thanks
Solved by I. D. in 12 mins