Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-21-2022, 07:19 AM
Manikandan Manikandan is offline Custom format Windows 10 Custom format Office 2021
Novice
Custom format
 
Join Date: Jun 2022
Posts: 1
Manikandan is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-23-2022, 02:30 AM
Debaser's Avatar
Debaser Debaser is offline Custom format Windows 7 64bit Custom format Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Posts: 192
Debaser is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom format 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 Custom format a merge field paul h Mail Merge 2 09-09-2015 07:18 AM
Custom format 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft