View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AngieM
 
Posts: n/a
Default Cell Format & Dashes

I have a column of numbers. The first cell is formatted for accounting (with
$). If the amount is this cell is -0-, how do I keep from having a dash
inserted and still keep the $ sign in the cell? If I format the cell for
text, then it is tough to get the $ to line up with the $ in the sum.