Posted to microsoft.public.excel.programming

Mervyn Thomas Mervyn Thomas is offline

external usenet poster

Posts: 44

Date Format problem

I have a SAGE (UK company) accounts application which exports CSV files
containing dates in DD/MM/YYYY formats. On opening the CSV file with excel
(Office2000) some of the dates in quite a random fashion show as MM/DD/YYYY
which completely throws the reporting. I have asked Sage but wonder if
anyone else has experienced this and whether there is a better way of
formatting the source data so that it is more consistant??

Mervyn

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Format Problem - Date Overrides Format	Mary	Excel Discussion (Misc queries)	5	February 10th 10 05:49 AM
date format problem??	Steve[_9_]	Excel Discussion (Misc queries)	10	December 27th 07 11:23 PM
Date format problem	Natalie	Excel Worksheet Functions	4	June 7th 07 01:28 PM
Date Format problem	nastech	Excel Discussion (Misc queries)	2	January 18th 06 01:54 AM
date format problem	Nigel	Excel Discussion (Misc queries)	7	May 11th 05 12:57 PM

All times are GMT +1. The time now is 03:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us