XL: Negative Symbol Not the Same as Windows 95 Setting

 Last reviewed: January 10, 1997
Article ID: Q136086
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 5.0, 5.0c
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel 97 for Windows

SYMPTOMS

In the versions of Microsoft Excel listed at the beginning of this article, the negative symbol in Microsoft Excel appears as a minus sign regardless of the Regional Settings in Windows 95 Control Panel.

WORKAROUND

To control the appearance of negative numbers in Microsoft Excel, use a custom number format. For example, use the following custom number format: 

   #,##0;"*"#,##0
Note that the format code "#,##0" is used as an example. You can use any valid number format as long as the character you want is enclosed in quotation marks at the beginning of the second portion (after the semicolon) of the custom format.

Microsoft Excel versions 7.0 and 97

To create a custom number format, use the right mouse button to click a cell and then click Format Cells on the submenu. Click the Numbers tab, and select the Custom category. In the Type box, enter the character you want to use as the negative sign. For example, if you want negative numbers to be preceded by an asterisk (*) rather by a minus sign (-), enter the following custom number format: 

   #,##0;"*"#,##0

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about how to create custom number formats in Microsoft Excel 7.0, click the Index tab in Microsoft Excel Help, type the following text 

   formatting cells, number
double-click the selected text, then double-click "Create Custom Number Formats."

For more information about how to create custom number formats in Microsoft Excel 5.0, click the Index tab in Microsoft Excel Help, type the following text 

   custom number formats
and double-click the selected text.

KBCategory: kbusage
KBSubcategory: xlwin xlformat
Additional reference words: 3.00 4.00 4.00a 5.00 5.00c 7.00 8.00 97

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: January 10, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.