If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing CSV files with custom dates
I have a Excel 2003 spreadsheet that contains dates with the following custom format:
dd-mmm-yyyy hh:mm If I save the spreadsheet to a csv file the dates are saved in the custom format. When I reopen the csv file in Excel the dates all appear as dd/mm/yyyy hh:mm. Is there any way to preserve the formatting when the csv file is opened? |
#2
|
|||
|
|||
Importing CSV files with custom dates
If you open the .csv file in NotePad, it may look one way. But if you open it
in excel, it'll use the standard (short) date format. Maybe you could just format those cells with the date/time format that you want. Martin Hinchy wrote: I have a Excel 2003 spreadsheet that contains dates with the following custom format: dd-mmm-yyyy hh:mm If I save the spreadsheet to a csv file the dates are saved in the custom format. When I reopen the csv file in Excel the dates all appear as dd/mm/yyyy hh:mm. Is there any way to preserve the formatting when the csv file is opened? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
regarding importing xml files into visio 2003 | ravi kumar | Visio | 1 | May 17th, 2004 02:01 AM |
Using Custom forms when Importing data | Brian | Contacts | 1 | May 10th, 2004 06:11 PM |
Importing pst problems / dates moved | Buglady | Calendar | 0 | April 26th, 2004 07:31 PM |