Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
Dear experts,
I've a worksheet of which column D & E are for dates. However, in these 2 columns, the users input the dates in different format. I want to change the dates into one format only such as: 21-Feb-09 (dd-mmm-yy). However, I highlighed the cells and changed the format to "dd-mmm-yy", the original dates do not change and until I re-type the dates again. It's a headache exercise if I need to re-type the dates again, please advise any quick method to achieve my goal. Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
Place the cursor in the date cells and press F2 and give enter. For
converting bunch of cells and columns instead of pressing F2 and Enter continuously it can be converted using Delimit. But without seeing the data its difficult to suggest the option. If the above suggestion is not useful to you then post your data how the dates are entered in your excel. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Freshman" wrote: Dear experts, I've a worksheet of which column D & E are for dates. However, in these 2 columns, the users input the dates in different format. I want to change the dates into one format only such as: 21-Feb-09 (dd-mmm-yy). However, I highlighed the cells and changed the format to "dd-mmm-yy", the original dates do not change and until I re-type the dates again. It's a headache exercise if I need to re-type the dates again, please advise any quick method to achieve my goal. Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
It sounds like the dates were entered or imported as text. If they are you
could temporarily enter a new column to the right and use: =datevalue(D2) That would convert the text date to a value date. Format it however you wish. Then copy, paste special, values back over column D. lastly remove the new temporary column D. I hope that helps. Frank "Freshman" wrote: Dear experts, I've a worksheet of which column D & E are for dates. However, in these 2 columns, the users input the dates in different format. I want to change the dates into one format only such as: 21-Feb-09 (dd-mmm-yy). However, I highlighed the cells and changed the format to "dd-mmm-yy", the original dates do not change and until I re-type the dates again. It's a headache exercise if I need to re-type the dates again, please advise any quick method to achieve my goal. Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
Hi Frankwood,
Thanks for your tips. However, it didn't work. I don't know how the users entered the dates. Their dates are mostly, for example - 25 February, 2004. I checked the cell format and it was a date format like 01-Mar-05. Apparently, it looks OK but I don't know why your tip didn't work. Anyway, I used a more complicated method to solve this problem and it was done. Thanks anyway. Best regards. "FrankWood" wrote: It sounds like the dates were entered or imported as text. If they are you could temporarily enter a new column to the right and use: =datevalue(D2) That would convert the text date to a value date. Format it however you wish. Then copy, paste special, values back over column D. lastly remove the new temporary column D. I hope that helps. Frank "Freshman" wrote: Dear experts, I've a worksheet of which column D & E are for dates. However, in these 2 columns, the users input the dates in different format. I want to change the dates into one format only such as: 21-Feb-09 (dd-mmm-yy). However, I highlighed the cells and changed the format to "dd-mmm-yy", the original dates do not change and until I re-type the dates again. It's a headache exercise if I need to re-type the dates again, please advise any quick method to achieve my goal. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
Convert european foreign date format to US date format | Excel Worksheet Functions | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |