Excel keeps adding in my date as part of my sum

  • Thread starter Thread starter Danika Allen
  • Start date Start date
D

Danika Allen

I have a spreadsheet where the date is the column header, and I have a series
of numbers below that. When I highlight the entire column to use the sum
that pops up in the status bar, it is also picking up the date as a number
and adding that in. I've tried to change the format of the cell to be a
date, but it still picks it up. How do I stop this?
 
You really can not stop it summing so long as your date is an actual Date.
Dates are stored as numbers and formatted as a date. If you want to get
around this convert the date to text with a formula something like this
(assuming your date is stored elsewhere)...

=text(A1, "mmm dd, yyyy")
where your date is in Cell A1

Or

Change the format of the cell to Text and then retype your date...
 
Back
Top