Excel Date Function to interprete dates as DD/MM/YYYY

[Guest]

Does anyone know of an Excel function to interpret an imported date as
DD/MM/YYY (i.e. Australian / British format) instead of interpresting it as
U.S. format (MM/DD/YY).

Have recently upgraded to Office 2003 and am now finding that the new excel
is intrepreting dates in reports imported from MYOB Accounting, as MM/DD/YY
when they are actually DD/MM/YY.

Have just to fix the date in each line on a 2,000-line imported ledger
detail report.

Doesn't MS realize that people do actually live outside the U.S. ?

Kym Yeoward
Alice Springs NT
Australia
22/03/2005

 

[Jan Karel Pieterse]

Hi KymY,

Does anyone know of an Excel function to interpret an imported date as
DD/MM/YYY (i.e. Australian / British format) instead of interpresting it as
U.S. format (MM/DD/YY).

Is this a csv file? If so, try changing the extension to e.g. .txt before the
import, so Excel will show you the text import wizard. In one of it's steps
you can define what date order it needs to assume for each column.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com