View Single Post
  #1   Report Post  
pkedward pkedward is offline
Junior Member
 
Posts: 1
Default Format the cells

I want to have the following format on the cells.

If the cell with the absolute value is less than 0.05, display ^^ except 0, while display '--' if the cell contain 0. The other value display as General currency format (e.g. $523,000).

Thanks.