Excel keeps adding in my date as part of my sum
 

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?

Excel keeps adding in my date as part of my sum
 

You could input the date as text by starting the enty with '.

"Danika Allen" wrote:

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?

Excel keeps adding in my date as part of my sum
 

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...
--
HTH...

Jim Thomlinson


"Danika Allen" wrote:

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?