I don't know what I was doing wrong, but I thought yyyy would work and it
didn't, but entered exactly as you have and it did.
Thanks for the quick reply and helpful answer.

"Mike H" wrote in message
...
Hi

with your date in a1
put this in b1
=A1 and a custom format of yyyy


Mike

"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