Money: Date Does Not Display When Imported from Excel PSS ID Number: Q104462 Article last modified on 09-13-1994 PSS database name: HOMETOOL
2.00 WINDOWS
The information in this article applies to: |
- Microsoft Money version 2.0 |
SYMPTOMS
Dates will not display in Money if the entries were imported from Microsoft Excel in one of the following formats dd-mmm mmm-dd dd-mmm-yy mmm-yy where d = Day, m = Month, and y = Year.
RESOLUTION
Dates entered in an Excel spreadsheets must be formatted as dd/mm/yy in order to be successfully imported into Money using the Excel to QIF format conversion macro.
Additional reference words: 2.00 2.00a 2.0a MS ss
============================================================================= Copyright Microsoft Corporation 1994.