Customize number format to show red and dollar sign and brackets

P

President

Board Regular
Joined
Aug 27, 2014
Messages
130
please see screenshot below.

the one shows in red is the custom format i need

UGljN78.png
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
Re: questiion on how to customize number format to show red and dollar sign and brakets

Try this,

Code: 
$* #,##0.00;[Red]$* (-#,##0.00);$* "-"??;@

It produces a hyphen for zero values.
 
Upvote 0
Re: questiion on how to customize number format to show red and dollar sign and brakets

Too slow
 
Last edited:
Upvote 0
Re: questiion on how to customize number format to show red and dollar sign and brakets

Thank you for telling us we solved your problem.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Custom Format "T" unable to replicate
Replies
1
Views
53
Peter_SSs
Peter_SSs
K
  • Solved
problem showing Brackets around negative numbers (formatting)
2
Replies
13
Views
701
KalilMe
K
J
  • Solved
Remove decimal point and numbers after decimal point using custom number formatting
2
Replies
13
Views
290
Fuji
F
S
  • Solved
I need help with creating a custom time format
2
Replies
12
Views
260
Asbestos_Jen
Asbestos_Jen
S
  • Question Question
Excel Custom formats with conditions
Replies
2
Views
396
saboh12617
S

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top