Microsoft KB Archive/103614

{|
 * width="100%"|

Excel: Font Substitution When Point Size Smaller Than 8

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0a, 5.0

-

SYMPTOMS
In the versions of Microsoft Excel listed above, when you use a font with a point size less than 8 points, the font will be displayed with the Small Fonts screen font and numbers containing decimal points may not align correctly.

CAUSE
When the font size is less than 8 points, Microsoft Excel substitutes the Small Fonts screen font, which is a proportional space font. This font substitution affects the screen only. Your data will be printed with the correct font if that font is available in the chosen point size.

WORKAROUND
To line up the decimal points correctly, add the following statement to the [Microsoft Excel] section of your EXCEL4.INI or EXCEL5.INI file: 

  Fontsub=0 This setting turns off font substitution for fonts smaller than 8 points and allows the desired fixed-width font to be used.

Steps to Reproduce the Problem
 In a new worksheet, select cells A1 through A3. From the Format menu, choose Font and select a screen font such as Helvetica or MS Sans Serif. In the Size box, type "6" (without the quotation marks).  In cells A1:A3, type the following:       A1:  1.111 A2: 4.444 A3: 2.222 

NOTE: The decimal points do not line up.

Additional query words: 4.00a proportional alignment TrueType True Type printer monospace

Keywords :

Version : 4.00a 5.00

Platform : WINDOWS

Issue type :

Technology : kbvcSearch