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 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?

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?