View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default display substitution?

I have a large spreadsheet which references cells from other spreadsheets.
There are hundreds of dates on the spreadsheet that are reported as
0-Jan-1900 because they are superseded or unused in the individual sheets. Is
there a way in which I can insert a command to display nothing if
date=0-Jan-1900, so that only relevant material is presented?

Thank you!