Problem in saving Date and $ field in Excel to CSV file

P

Peter

We just copy and paste data from MS Access 2003 to Excel 2003.

When we save the Excel as CSV file, we find that the date has been converted
to American format. We have checked the Regional Settings and Australia is
used. Is there any language setting in Excel ?

Moreover, on another machine, we are able to save to non-American date.
However, we find that for monetary field, most of them are quoted - Like
"$2,000.00" but some are not quoted - like $580.00. Your advice is sought.

Thanks
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem in saving Date Field in Excel file to CSV 1
Doughnut Chart linked with the slicer in the pivot table 0
How to remove CSV file-saving warning 1
CSV files and having numbers and strings in there... 9
CSV and Custom Fields 6
Excel to Word to PDF workflow 1
CSV file date format 3
Problem formatting dates from CSV file 2

Top