| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Number
Hey How do a get a negitve number to be bracketted rather than showing the "-" sign. I'm also using thousand seperators. Cheers -- Embalmer ------------------------------------------------------------------------ Embalmer's Profile: http://www.excelforum.com/member.php...o&userid=17907 View this thread: http://www.excelforum.com/showthread...hreadid=497197 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Number
<Format <Cells <Number tab,
And click on "Number' in the left window, And on the right side you'll see a choice of 4 or 5 negative formats, And also you can click on "1000" separators. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Embalmer" wrote in message ... Hey How do a get a negitve number to be bracketted rather than showing the "-" sign. I'm also using thousand seperators. Cheers -- Embalmer ------------------------------------------------------------------------ Embalmer's Profile: http://www.excelforum.com/member.php...o&userid=17907 View this thread: http://www.excelforum.com/showthread...hreadid=497197 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Number
Hi,
Select the cells -- "Format" -- "Cells" -- click on "Number" Tab, select "Number", check "Use 1000 separator", choose an appropriate format for "Negative Numbers" -- "OK" Regards, B. R. Ramachandran "Embalmer" wrote: Hey How do a get a negitve number to be bracketted rather than showing the "-" sign. I'm also using thousand seperators. Cheers -- Embalmer ------------------------------------------------------------------------ Embalmer's Profile: http://www.excelforum.com/member.php...o&userid=17907 View this thread: http://www.excelforum.com/showthread...hreadid=497197 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number format button | Excel Discussion (Misc queries) | |||
| Custom number format - Accounting | Excel Worksheet Functions | |||
| Custom Number Format... | Excel Worksheet Functions | |||
| Custom Number formatting | Excel Worksheet Functions | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
