ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Negative Number Format () Not available (https://www.excelbanter.com/excel-discussion-misc-queries/50322-negative-number-format-not-available.html)

MAX258

Negative Number Format () Not available
 

Hi Folks,

I do not have the negative number format using parenthesis (55)
available in excel. I have gone to my regional settings and changed
the number type to ( ) but I still don't get the option.

Anybody have any other fixes besides using custom formats?
Thanks in advance/
Max


--
MAX258
------------------------------------------------------------------------
MAX258's Profile: http://www.excelforum.com/member.php...fo&userid=1538
View this thread: http://www.excelforum.com/showthread...hreadid=476010


Dave Peterson

Maybe....

Windows start button|settings|control panel|regional settings
(Or regional and language settings in winXP)

Regional Options tab, customize button in winxp

Currency Tab
change the negative currency format to show ()'s.

MAX258 wrote:

Hi Folks,

I do not have the negative number format using parenthesis (55)
available in excel. I have gone to my regional settings and changed
the number type to ( ) but I still don't get the option.

Anybody have any other fixes besides using custom formats?
Thanks in advance/
Max

--
MAX258
------------------------------------------------------------------------
MAX258's Profile: http://www.excelforum.com/member.php...fo&userid=1538
View this thread: http://www.excelforum.com/showthread...hreadid=476010


--

Dave Peterson


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com