 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Problem in saving Date Field in Excel file to CSV
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 "Peter" <Peter@discussions.microsoft.com> wrote... >We just copy and paste data from MS Access 2003 to Excel 2003. Meaning you're at the mercy of how Microsoft implements that particular operation. Try Paste Special to see what you options are. >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? What specific date formats are you using? Meaning are your months shown as text, e.g., Sep or September, or as numbers? >Moreover, on another machine, we are able to save to non-American date. Again, what specific date format? >However, we find that for monetary field, most of them are quoted - Like >"$2,000.00" but some are not quoted - like $580.00. . . . This could occur because of the comma. Excel may consider both $2,000.00 and $580.00 to be TEXT, but the former contains an embedded comma, which is presumably also your List Separator character per Windows Regional Settings. That embedded comma would mean $2,000.00 would need to be quoted, but no comma in $580.00 would mean it wouldn't need to be quoted. This could also explain why your dates aren't munged on this other PC: Excel may consider them to be TEXT as well. Are you copying the EXACT SAME table or query result from the same database using the same versions of Access and Excel on both these PCs? If so, then there's got to be some difference(s) in the regional settings OR Excel's override international settings on both PCs.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.