Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting negative numbers in Excel
I'm sorry guys but I have tried all these options as well as restarting Excel
and the options for negatives in brackets are still not achievable. It surprises me really that this is not the defualt. "Cutter" wrote: Click on FormatCells...Number Tab Under Category click on Number Choose your format from the window on the right side -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=276405 |
#3
|
|||
|
|||
I've done both suggestions and no success. I am in Australia region. Also how
do I make certain customisations to automically apply to all worksheets I open by default "Gord Dibben" wrote: Re-read my post. The change in Regional Options is done under "Currency" not "Number". Gord On Wed, 1 Jun 2005 17:18:01 -0700, "Negative numbers in brackets" <Negative numbers in wrote: I'm sorry guys but I have tried all these options as well as restarting Excel and the options for negatives in brackets are still not achievable. It surprises me really that this is not the defualt. "Cutter" wrote: Click on FormatCells...Number Tab Under Category click on Number Choose your format from the window on the right side -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=276405 |
#4
|
|||
|
|||
When all else fails, there is the somewhat nasty option of defining a CUSTOM entry of "$ "#,##0.00;[Red]-"($ "#,##0.00" )" which should produce your required result -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=276405 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
formatting numbers | Excel Worksheet Functions | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
Subtracting Negative Numbers | Excel Worksheet Functions |