I have a MacBook Pro. I'm trying to total a column of numbers using SUM formula in a Numbers spreadsheet. One column totals fine. The column next to it shows a date and time in the SUM cell instead of the total of the numbers in the column. I can't figure out how to fix it.
MacBook Pro with Retina display, OS X Mavericks (10.9.5)
Found it! In one of the numbers, there was a colon instead of a decimal point. All is well. Thank you so much for your help. There are 500 numbers in the column so I didn't see it when I scrolled through, but I went through each number individually with the format sidebar open and it popped up.
Found it! In one of the numbers, there was a colon instead of a decimal point. All is well. Thank you so much for your help. There are 500 numbers in the column so I didn't see it when I scrolled through, but I went through each number individually with the format sidebar open and it popped up.
There is a date somewhere in that list of numbers you are summing. A date + numbers = the date + that many days. For example, 1/1/18 + 2 + 3 = 1/6/18
I was hopeful that might be it but I can't find a date or time or anything that resembles a date or time in the column so I'm still stuck. Any other ideas?
Numbers SUM formula shows as date and time
