i'm preparing the cheque import file.
date column should be in YYYY/MM/DD. right?

but my own data are in DD-MM-YYYY format. any quick way or tools to changet the date format, i dun want to retype all the hundred records.

please hlep.

Yes. The date column should be in format YYYY/MM/DD.

You can follow the steps below to change date format in excel
================================

1. Highlight the cells you'd like to change

2. Right click your mouse to show the popup menu

3. Click "Format Cell"

4. In the Number tab, choose "Date" and select the type as YYYY/MM/DD

5. Click OK when done.

6. You can save the file as CSV and view with a text editor for confirmation.

================================

Sorry for a bit late of this post.

But, where can I find the import file?

(10-28-2009 03:39 AM)Guest Wrote:  Sorry for a bit late of this post.

But, where can I find the import file?

When you click the Import button, a dialog will be shown out.

There is a link of "Sample File" in the dialog, you can click the link and it will load the sample import file in your excel.

Regards,