HELP! import file
Author Message
Ted Kuma
Guest

 
#1
HELP! import file
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.
10-14-2009, 11:32 AM
Reply
support Offline
Technical Support
******

Posts: 302
Threads: 19
Joined: Nov 2006
#2
RE: HELP! import file
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.

================================
Technical Support
Evinco Solutions Limited
http://www.evinco-software.com
- Provides innovative business software
10-14-2009, 12:25 PM
Find Reply
Guest
Guest

 
#3
RE: HELP! import file
Sorry for a bit late of this post.

But, where can I find the import file?
10-28-2009, 04:39 PM
Reply
support Offline
Technical Support
******

Posts: 302
Threads: 19
Joined: Nov 2006
#4
RE: HELP! import file
(10-28-2009, 04:39 PM)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,
Technical Support
Evinco Solutions Limited
http://www.evinco-software.com
- Provides innovative business software
10-28-2009, 04:48 PM
Find Reply
 
« Next Oldest | Next Newest »

View a Printable Version
Send this Thread to a Friend
Subscribe to this thread |

Forum Jump:

Contact Us | Evinco Solutions Limited | Return to Top