Format %

sythong

Active Member
Joined
Jun 26, 2004
Messages
324
Morning friends

Currently my percentage formatting is set as "Percentage" - "2". This is fine when
it does not show zero (e.g 0.01%). However I would prefer it to show "-" instead of
0.00% which could be quite confusing for me to read.

Perhaps there might be a custom format to show "-" instead of 0.00%.


Thanks
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,793
Office Version
  1. 2019
Platform
  1. Windows
0.00%;-0.00%;-;@

Does that work?
 

sythong

Active Member
Joined
Jun 26, 2004
Messages
324
Xenou


Thank you very much. I would not have made it on my own
and at such short time.
Before I posted the question I did try custom format 0.00%;-.
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,793
Office Version
  1. 2019
Platform
  1. Windows
My pleasure. The semi-colons separate positive, negative, and zero formats - so the zero format must be after the second semi-colon. Text values trail at the end ("@" is an all-purpose text format).

Enjoy the rest of your day,
xenou.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,918
Members
414,110
Latest member
docops

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
Top