Hi

do you actual type
Jan 1 05
into a cell ... if so, excel doesn't (on my system anyway) recognise it as a
date ... try entering your dates using either the / or the -
e.g.
1/1/05
(less typing too)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"date formats morph the dates/chang case" <date formats morph the
dates/chang wrote in message
...
Please, I'm just getting farther from the answer and I have to be up for
church soon. First question. I'm obtuse but when I type in a date, eg
jan 1
05 and then format/cell/date I select a date format and it morphs in to a
completely different date.

2nd question: to change case, use UPPER or LOWER function. But, how
does
that work to use the cell itself or a group of cells.

If anyone can help, I'll owe you forever.

carrie, washington state