HELP ME PLEASE!!!
We have recently upgraded to Office 2003 and now when we send a file from MYOB to Excel the dates have changed to month/day/year for less than day 12 and text for day more than 12. I just can't seem to work out what to do so I can pickup the correct date dd-mmm-yy format in another spreadsheets formula!!!!!!!!!!!
For anyone who can help me thank you in advance
ray:
We have recently upgraded to Office 2003 and now when we send a file from MYOB to Excel the dates have changed to month/day/year for less than day 12 and text for day more than 12. I just can't seem to work out what to do so I can pickup the correct date dd-mmm-yy format in another spreadsheets formula!!!!!!!!!!!
For anyone who can help me thank you in advance
ray: