#1
|
|||
|
|||
Custom format
I want compact number(k or Million or Billion) with color as "red" for negative number For example [<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B" 1) It should support negative number with paratheses ex: (#) 2) Negative number color should support. 3) It should support positive and negative numbers with compact format. Ex: Number 1.23K 3.9M (2.5M) 5.6B |
#2
|
||||
|
||||
You can't do all of that with a custom number format. You would need to use conditional formatting rules (or code) to apply different formats.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom format 4 digit number to 0:00 | Marcia | Excel | 5 | 06-05-2021 11:06 PM |
Custom Date Format - MM/YYYY | ProjectUser | Project | 0 | 10-28-2019 03:21 PM |
Custom format a merge field | paul h | Mail Merge | 2 | 09-09-2015 07:18 AM |
Creating a custom number format | bremen22 | Excel | 2 | 01-16-2014 07:23 AM |
Custom Number Format for Chart | deadrxn24 | Word | 4 | 03-18-2012 05:38 PM |