Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
General;[Red]-General -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "GeraldM" wrote in message ... Is there a way to format negative numbers in red WITHOUT fixing the decimal precision. i.e. if a cell is formatted as "general" then the number 1 displays as 1 and 1.23 displays as 1.23 etc. So I need a "general" type formatting but showing negatives as red (and signed). Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting negative numbers to equal zero | Excel Discussion (Misc queries) | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
Quick formatting for negative numbers | Excel Worksheet Functions | |||
Formatting negative numbers in Excel | Excel Discussion (Misc queries) |