View Single Post
 
Old 10-27-2013, 03:20 AM
sala-marie sala-marie is offline Windows 7 64bit Office 2000
Novice
 
Join Date: Oct 2013
Posts: 3
sala-marie is on a distinguished road
Default

Hi. Thanks for the reply. As I have only just joined, and entered Auckland as my Time Zone, that means I'm in New Zealand, which uses the 'European' date format of DD/MM/YYYY. The 4 digits for the year seems to satisfy all potential import receiving programs, hence you will see that used in the body of my query.

But you are right. I didn't 'spell it out'. As for 'no clue'.......? I would have thought there were 'clues' aplenty ! But I should have said.

So thanks for your suggestion, and I will try that. But the problem, as I have stated, is only when there is a single digit in the DAY part of the date field. The first 2 characters before the first separator. The problem only occurring when the first character is a zero, which Excel drops in a .csv file.

But I'll give it a go.
Thanks,
Reply With Quote