LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default formatting negative numbers

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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting negative numbers to equal zero kjhxsh Excel Discussion (Misc queries) 3 September 4th 09 05:47 AM
Excel, change column of negative numbers to positive numbers? Nita New Users to Excel 3 November 27th 07 04:54 AM
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM
Quick formatting for negative numbers Mulepadre Excel Worksheet Functions 1 March 25th 06 03:09 AM
Formatting negative numbers in Excel Negative numbers in brackets Excel Discussion (Misc queries) 3 June 2nd 05 06:37 AM


All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"