Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert european foreign date format to US date format
I receive dates in the following format in column:
dd.mm.yyyy I would like to convert the column to read mm/dd/yyy. Any thoughts? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert european foreign date format to US date format
If they're really dates with that custom format, you could just change the
format of those cells. But if the values in the cells are text, you can select the column Data|Text to columns Fixed width Remove any line that excel guessed and don't add any of your won choose Date (dmy order) And finish up the wizard. Then format that column to show the date the way you like. EAL wrote: I receive dates in the following format in column: dd.mm.yyyy I would like to convert the column to read mm/dd/yyy. Any thoughts? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
how can i change european date format to american | Excel Discussion (Misc queries) | |||
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT | New Users to Excel | |||
CONVERT 11/23/04 US DATE FORMAT TO EUROPEAN 23/11/04 FATE | Excel Discussion (Misc queries) |