Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
importing csv files and dates
hi,
i have to import a csv file into excel on a regular basis. The file contains some data that are dates. For some reason excel insists on converting some of the dates into m/d/y format rather than d/m/y. I cant figure out why. Any clues anyone? does anyone have a way of converting one format to the other? TIA Pete |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
importing csv files and dates
Pete,
using the text import or text to columns wizard...in step three there is a column data format box on the top right of window where you can select the formatting of dates. hth, Dave "jiwolf" wrote: hi, i have to import a csv file into excel on a regular basis. The file contains some data that are dates. For some reason excel insists on converting some of the dates into m/d/y format rather than d/m/y. I cant figure out why. Any clues anyone? does anyone have a way of converting one format to the other? TIA Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use an Excel 1997 files with line chart that have date & ti | Charts and Charting in Excel | |||
Getting Excel on new computer to show dates like on old | Excel Discussion (Misc queries) | |||
space before date in csv files | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Converting numbers to date format from csv files | Excel Discussion (Misc queries) |