On Tue, 11 Oct 2005 13:05:05 -0700, Blaise
wrote:

Ron,

Thanks for your very helpful reply. I think the reason it worked before is
that I changed the cell format but didn't actually type in the cell. Your
description of what Excel is doing makes sense. Well, for Excel it makes
sense. :)

For my purposes, I can use the Number type. It doesn't have to be Date type.
I was just stuck on the fact that "1994" is a year in the human context, so
tried to format it that way.

Thanks again.

Blaise

You're welcome. Glad to help.

--ron