View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maria Maria is offline
external usenet poster
 
Posts: 71
Default Hide formula result values until all components are entered

I have a column with a formula to calculate a date based on a date entered in
the previous column. I want the result in the column to be blank until the
date is entered. Now it reads 01/01/00 until I enter a date for it to
calculate correctly. Please help!