Microsoft KB Archive/28222

= Microsoft Knowledge Base =

File: Transferring Dates from Excel
Last reviewed: October 26, 1994

Article ID: Q28222

Summary:

When you use the Copy and Paste commands to bring dates from Microsoft Excel to Microsoft File, the value &quot;#ERROR&quot; will appear in the date fields in File.

To get dates from Excel to File, do the following:


 * 1) In Excel, select all cells that contain dates.
 * 2) From the Format menu, choose Number.
 * 3) Select the &quot;m/d/yy&quot; format in the list box.
 * 4) From the File menu, choose Save As. Click the Options button.
 * 5) Select Text and click OK. Give the file a name and save it.
 * 6) Start File and create a new data file.
 * 7) Close the form, and choose Open Datafile from the File menu.
 * 8) Open the text file that was saved from Excel.