View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
recrit recrit is offline
external usenet poster
 
Posts: 20
Default 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