Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
Hi Helene,
A couple of questions: (a) I take it that right now negative numbers show up as if they were positive, e.g., minus 35 shows up on your worksheet as "35." Correct? (b) In Control Panel did you change the regional setting for numbers, for currency, or for both? Regards, Batara "Hélène" wrote: Thank you for your reply. They are seen as numbers, I have not forced any alignment and they are right-aligned, by default. I have seen multiple suggestions on this site, I have tried them all, except for the "unregister/register", etc. Could it be a bug? "Peo Sjoblom" wrote: Are they seen as numbers at all? Widen the cell, don't force any aligment, are the numbers left or right aligned, if they are left they are seen as text you can also try =ISTEXT(cell) if it returns TRUE they are text, if so try copy an empty cell, select the numbers and do paste special and select add. -- Regards, Peo Sjoblom "Hélène" wrote in message ... Hi, I have read every questions and replies on this site in order to get my negative numbers to show in brackets and nothing works. I am desparate. The regional settings are changed to indicate negative numbers in brackets but when I try formatting the cells in Excel, I cannot get the numbers to show in brackets. I have Windows XP, Office 2003. Please help me... Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get negative numbers to show as brackets? | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
Subtracting Negative Numbers | Excel Worksheet Functions | |||
Negative Numbers | Excel Discussion (Misc queries) |