Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
How do I format a value when using it within a cell reference tha. | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |