Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Conversion dd.mm.yyyy to dd/mm/yyyy
Hi,
I have a proprietary program which exports date time values to a text file in this format dd.mm.yyyy and i would like to be able to work with these values in excel, but of course excel likes dates to be in dd/mm/yyyy format. Any ideas on how to go about converting them? Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Conversion dd.mm.yyyy to dd/mm/yyyy
Select your range of dates
Goto the menu EditReplace Find what: . (enter a period) Replace with: / Replace all Close Now, if you're OS settings for date are English (U.S.) then the default date format is m/d/yyyy. After doing the EditReplace the dates are still TEXT strings. To convert them to real dates: Select the range of dates Goto the menu DataText to Columns Click NEXT twice In step 3 of the wizard under Column data format select DateMDY Finish -- Biff Microsoft Excel MVP "ScottRA" wrote in message ... Hi, I have a proprietary program which exports date time values to a text file in this format dd.mm.yyyy and i would like to be able to work with these values in excel, but of course excel likes dates to be in dd/mm/yyyy format. Any ideas on how to go about converting them? Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
convert date mm/dd/yyyy to dd/mm/yyyy | Excel Worksheet Functions | |||
how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
change birthday display from mm/dd/yyyy to HIDE the yyyy? | Excel Worksheet Functions |