the dates on cell format make different dates.

[date formats morph the dates/chang case]

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 (e-mail address removed)

 

[JE McGimpsey]

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

date formats morph the dates/chang case <date formats morph the

 

[JulieD]

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 (e-mail address removed)> wrote in message
news:[email protected]...

 

[Ragdyer]

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.

 

[date formats morph the dates/chang case]

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.

 

[date formats morph the dates/chang case]

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

 

[Ragdyer]

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.