| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in data imported from MYOB to Excel 2003
When sending a report from MYOB (Version 13) to Excel 2003 the date in the
Excel spreadsheet is incorrect. This problem did not occur in Excel 2000. Some dates in the Excel report show as MM/DD/YYYY (Regional Settings are DD/MM/YYYY) and others it changes to text. Reformatting the dates in Excel 2003 does not fix the problem as the numeric value of MM/DD/YYYY is there for some and the others are text and not dates. ie the data is inaccurate by the time it is shown in the Excel 2003 report. Is there something I can do to solve this annoying problem? I would really appreciate assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Imported Data (Excell 2003) | Excel Worksheet Functions | |||
| Excel data to MYOB | New Users to Excel | |||
| Why do reports from MYOB to Excel alter the date format | Excel Discussion (Misc queries) | |||
| Formatting on imported data (Excel 2003) | Excel Discussion (Misc queries) | |||
| Exporting from MYOB to Excel the date cell doesn't display as dat. | Excel Worksheet Functions | |||
Linear Mode
