Microsoft KB Archive/100769

WD5X: Number Formats Not Converted from Excel Worksheet on Mac

PSS ID Number: Q100769 Article last modified on 11-26-1998

MACINTOSH: 5.0, 5.1

MACINTOSH

================================================================ ==

The information in this article applies to:

 == Microsoft Word for the Macintosh, versions 5.1, 5.1a == 

= SYMPTOMS =

Numbers in the Date, Fraction, or Time Number format may not be converted correctly from a Microsoft Excel spreadsheet into Microsoft Word.

All Date formats are converted as “#######” (without the quotation marks). Numbers formatted as Fractions may lose their fraction value. For example, “3 1/2” becomes “3”. When you convert numbers formatted as Time (such as “3:36 P.M.”), part of the time may be replaced with garbled characters.

= WORKAROUND =

To import these number formats, save the spreadsheet in Microsoft Excel in an ASCII file format, such as Comma-Separated Value (CSV) or Text.

To save a Microsoft Excel spreadsheet in CSV or text format, follow these steps:


 * 1) Open the Microsoft Excel spreadsheet. On the File menu, click Save As.
 * 2) Click Options and in the File Format list, select CSV or Text. Click OK.
 * 3) In the Save Worksheet As box, type a new file name and click Save.

When you open the spreadsheet in Word, the values from the spreadsheet will be comma separated (CSV) or tab separated (Text). To restore the data to table format:


 * 1) Highlight the text.
 * 2) On the Insert menu, click Text To Table.
 * 3) In the Insert Table dialog box, verify Convert From has the correct delimiter selected (Tab Delimited or Comma Delimited). Click OK to accept the number of Columns and Rows Word proposes for the data.

= STATUS =

Microsoft has confirmed this to be a problem in Word versions 5.1 and 5.1a for the Macintosh. This problem was corrected in Microsoft Word 6.0 for the Macintosh.

Additional query words: m_excel appsconv garbage print merge document conversion ====================================================================== Keywords : kbinterop macword kbtable Version : MACINTOSH: 5.0, 5.1 Platform : MACINTOSH Issue type : kbbug Solution Type : kbfix ============================================================================= Copyright Microsoft Corporation 1998.