Problem with Dates in the CSV file,

[arghh2010]

Entry Start Date   Entry End Date
10/1/2027 17:00   10/1/2027 18:00

Above is how Excel parses the dates for this format.
Tried many custom format and could not make it work.

The text sent is 2010-01-27
I would expect Excell to show me Jan 27 2010, not  Jan 10 2027. 

[Charles Augustine]

Hi there,

Unfortunately the only copy of Excel I have to test with works fine when interpreting 2010-01-27 as a date in 2010 (it shows me Jan 27, 2010).  What version of excel/office are you using?

-- Charles

[qwerty20]

Actually, I'm not good at Excel.

[phelpme]

Sorry, can't help that