| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert dates
I have downloaded a table that displays dates with a M/D/YY format. On my
PC, the format for dates is DD.MM.YY. How do I convert from the text in the date colum of the downloaded table, to a date displayed in my PC's format? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert dates
One way is to use Data Text to Columns to convert the source text dates to
real dates. Try this: Select the source col of dates, click Data Text to Columns. Click Next Next. In step 3 of the wiz., under Column Data Format, check "Date", then choose MDY from the droplist. Click Finish. Now you can custom format the dates in the column to taste. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "hmm" wrote: I have downloaded a table that displays dates with a M/D/YY format. On my PC, the format for dates is DD.MM.YY. How do I convert from the text in the date colum of the downloaded table, to a date displayed in my PC's format? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert dates
Thanks Max. It did the job.
"Max" wrote: One way is to use Data Text to Columns to convert the source text dates to real dates. Try this: Select the source col of dates, click Data Text to Columns. Click Next Next. In step 3 of the wiz., under Column Data Format, check "Date", then choose MDY from the droplist. Click Finish. Now you can custom format the dates in the column to taste. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "hmm" wrote: I have downloaded a table that displays dates with a M/D/YY format. On my PC, the format for dates is DD.MM.YY. How do I convert from the text in the date colum of the downloaded table, to a date displayed in my PC's format? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert dates
You're welcome.
Good to hear that. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "hmm" wrote in message ... Thanks Max. It did the job. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Converting Dates to 8 digits | Excel Worksheet Functions | |||
| How can I convert Euro dates into U.S. Date; e.g. dd-mm to mm-dd? | Excel Worksheet Functions | |||
| How to convert the dates from the YY:DD forma to MM/dd/YYYY format | Excel Worksheet Functions | |||
| Convert three separate columns of values to dates | Excel Worksheet Functions | |||
Hybrid Mode
