Microsoft KB Archive/50317

From BetaArchive Wiki

Printing Hyphens Next to Page Number in Excel Footers PSS ID Number: Q50317 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

Hyphens may be placed next to the page number in the footer of an Excel for Windows version 3.0 or Excel for OS/2 version 2.2 and 3.0 document. To do this:

  1. From the File menu, choose Page Setup.

  2. Type

    -&P–

    in the Footer text box.

The printed footer will look as follows:

-1-

More Information:

Excel 2.x

In Excel 2.x for Windows, you can get the same result by typing:

-&P—

Using a single hyphen after the page number makes Excel assume you want to subtract a number from the page number; the double hyphen that follows the single hyphen serves to cancel the first hyphen.

Reference(s):

“Microsoft Excel User’s Guide,” version 3.0, pages 529-530, 535

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.