Thread
:
Formatting Percentages
View Single Post
#
2
Posted to microsoft.public.excel.misc
recrit
external usenet poster
Posts: 20
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
Reply With Quote
recrit
View Public Profile
Find all posts by recrit