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.