Excel displaying American date format on imported data

  • Thread starter Thread starter maggie.sharpe
  • Start date Start date
M

maggie.sharpe

importing date from a progress database the format of the
date fields is automatically displaying in American
format. I have checked control panel etc and tried all
the usual stuff.

Anyone suggest anything else to check. I have a feeling
that there might be a "bug" fix that I might be able to
try but cannot remember?

Any suggestions would be appreciated
 
Hi

Have you tried changing the format of the cells from mm/dd/yy to Custom type
dd/m/yy ?
 
If it does that then it is probably text, select the import, do data>text to
columns,
click next twice and under column data format select date and MDY, then
click finish
(note that you have to select the imported format and US is MDY), now
hopefully
excel will convert to local date format, if not you need to see what's in
the import,
you might have trailing invisible funny chars

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top