Excel: Printing to LaserWriter Prints Number Signs (#)

Last reviewed: November 29, 1994
Article ID: Q46509
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 1.5, 2.2, 3.0, 4.0

SUMMARY

Microsoft Excel uses fractional widths and proportional spacing when dealing with fonts. This feature can cause a spreadsheet to print differently to an Apple LaserWriter from the way it appears on the screen. Fractional widths can cause the fonts to expand in size and produces number signs (#####) if the value is now too large for the column width to display. The number signs appear in Print Preview as well as in the printout.

MORE INFORMATION

The Fractional Widths feature tells the Macintosh to use the character widths defined for the LaserWriter fonts instead of the widths of the characters as they are displayed on the screen. Microsoft Excel version 1.50 prints to any output device at 72 dots per inch (dpi), while later versions of Microsoft Excel allow for higher resolution printing to high-resolution output devices. This difference in dpi can cause some version 1.50 documents to look different when they are printed from later versions of Microsoft Excel.


KBCategory: kbusage
KBSubcategory:

Additional words: 1.5 1.50 2.2 2.20 3.0 3.00 4.0 4.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.