Thread
:
the dates on cell format make different dates.
View Single Post
#
2
JE McGimpsey
Posts: n/a
1) What does the date morph into?
2) Take a look at David McRitchie's macros:
http://www.mvps.org/dmcritchie/excel/proper.htm#lower
In article ,
date formats morph the dates/chang case <date formats morph the
dates/chang
wrote:
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.
Reply With Quote