Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do you format negative numbers to have brackets. I used to have the opion
in "number" in the old version but this has been lost..... |
#2
![]() |
|||
|
|||
![]()
As far as I know, you do this under Windows. Start, Settings, Control Panel,
Regional Options, Numbers, Negative number format "foxint" wrote: How do you format negative numbers to have brackets. I used to have the opion in "number" in the old version but this has been lost..... |
#3
![]() |
|||
|
|||
![]()
Thanks - seems to have worked - Great Mate
"Kassie" wrote: As far as I know, you do this under Windows. Start, Settings, Control Panel, Regional Options, Numbers, Negative number format "foxint" wrote: How do you format negative numbers to have brackets. I used to have the opion in "number" in the old version but this has been lost..... |
#4
![]() |
|||
|
|||
![]()
Try changing a windows setting.
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. foxint wrote: How do you format negative numbers to have brackets. I used to have the opion in "number" in the old version but this has been lost..... -- Dave Peterson |
#5
![]() |
|||
|
|||
![]()
foxint wrote in message ...
How do you format negative numbers to have brackets. I used to have the opion in "number" in the old version but this has been lost..... To have this as an option you need to change this in Regional Settings in the Control panel. Change your negative number format to include brackets around the number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions |