Microsoft KB Archive/104462

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.