View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Hannan Matt Hannan is offline
external usenet poster
 
Posts: 1
Default Excell cell formatting

I would like a selection of cells to display "-" unless text or a number is
typed in. However, if the text / number is subsequently deleted, I would like
the cell to revert back to "-".

Almost like the default content for the cell is "-" and not blank / empty