ExcelBanter - Formatting Percentages

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting Percentages (https://www.excelbanter.com/excel-discussion-misc-queries/193522-formatting-percentages.html)

Formatting Percentages

How do I make a 0.0% appear as a hash mark (-) ? Thanks.

recrit

Formatting Percentages

On Jul 2, 7:41*pm, JB wrote:
How do I make a 0.0% appear as a hash mark (-) ? *Thanks.

when formatting cell, you can define a custom format: 0.00%;
(0.00%); - order is <positive<negative<zero

All times are GMT +1. The time now is 10:46 PM.