Microsoft KB Archive/132969

= Microsoft Knowledge Base =

XL5: Negative Sign Doesn't Appear in Front of Custom Number
Last reviewed: September 12, 1996

Article ID: Q132969

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for Windows NT, version 5.0
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SUMMARY
Page 213 of the Microsoft Excel "User's Guide," version 5.0, contains the following information:

With this format               This number          Appears this way -

#.00 "Cr";#,##.00 "Dep";0.0   -12.34               -12.34 Dep This example is incorrect. The given format code will not put the negative sign in front of the number. To include a negative sign in front of the number, place a negative sign after the first semicolon as follows:

#.00 "Cr";-#,##.00 "Dep";0.0