Thank you for your quick reply and helpful answer.
"Dave Peterson" wrote in message
...
Make sure you format the cell with the =year() formula as General.

Right now you have it formatted as a date.

Pam wrote:

Hi,

I found a post that gave year function (=year(cell)) to extract only the
year from a date. I have 1/15/2006 and I get 6/28/1905. This date was
exported from Access into an Excel spreadsheet. I'm not sure if that
would
have an effect on it, but thought I would include it in message. If I
format the new column to a number, I get 38722. I know Access uses
numbers
for dates, so I need to somehow convert to get correct year.

Can anyone help me get 2006 from 1/15/2006?

Thanks in advance for any help,
Pam

--

Dave Peterson