the dates on cell format make different dates.
 

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

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.

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

you *can* type:

jan 1, 05

And XL will recognize it as a date, BUT ... XL will display it as whatever
date format is set for that cell, verifying that it is recognized.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JulieD" wrote in message
...
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

Hi:
Thanks for the info. My problem was that I thought "format" put the date in
that format so I could type it without punctuation 41705 would format into
4-17-05 or Apr 17, 2005. But there's no way around typing 4/17/05, I guess.

"JulieD" wrote:

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

Hi:
I think my problem was understanding "formatting" I thought you could
choose the format and then save time by typing 41705 and it would turn out
Apr 17, 2005 or 4-17-05 depending on the format. I guess there's no way
around inpur 4/17/05. Right?

Inputting 41705 gets you 7-mar-02

Carrie

If you were going to enter a *very* large number of dates into a column,
where you might consider it worthwhile using several *extra* steps in Text
To Columns (TTC), you could enter your dates using *6* digits (to avoid
ambiguity), *without* delimiters.

This entails a whole other procedure, so the saving wouldn't be realized
unless the number of dates to be entered was quite large.

For example, you could enter dates as mmddyy.
041705
121504
010105
101206
092504
122505

Then, select the cells, and
<Data <TextToColumns <Next <Next

Click on "Date", and make sure "MDY" shows in the window,
Then <Finish.

You've now made your 6 digit date entries recognizable to XL as *the* dates
that you want, not "morphed" into dates XL chooses.

As I said before, it's your call as to whether or not this extra effort is
efficacious.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"date formats morph the dates/chang case"
rosoft.com wrote in
message ...
Hi:
I think my problem was understanding "formatting" I thought you could
choose the format and then save time by typing 41705 and it would turn out
Apr 17, 2005 or 4-17-05 depending on the format. I guess there's no
way
around inpur 4/17/05. Right?

Inputting 41705 gets you 7-mar-02

Carrie