View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
sheana sheana is offline
external usenet poster
 
Posts: 10
Default Cell format - put hyphen where zero value would be.

I am working on an expenses spreadsheet, and I have the category of expenses
in column A. In the cells that would carry the numerical values, how do I
format the cell to show a hyphen where a value would eventually be,
indicating that the present value in the cell is zero?