Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying negative numbers - inconsistent between desktop and lap
On my desktop PC, in order to have the option of getting negative numbers in
Excel displayed in brackets I need to adjust the Negative Numbers setting in the Regional Settings part of the Control Panel€¦.this works fine. However, an identical approach to the same problem on my laptop does not allow the option of bracketing negative numbers. The Regional Settings are correctly set, but Im only offered red negatives, or numbers with a minus symbol. Is there another setting that I should check? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying negative numbers - inconsistent between desktop and lap
Hi, Try formatting the cells in Excel itself, select the Number tab, Custom and then select #,##0;(#,##0) hope that works for you -- penri0_0 ------------------------------------------------------------------------ penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947 View this thread: http://www.excelforum.com/showthread...hreadid=545418 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|