Microsoft KB Archive/104462

From BetaArchive Wiki

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.