Referencing Cells
 

Hi,

I have several columns with dates and text. For example.

1B text
1C date
1D date
1E text
1F date

Sometimes the fields are blank. When I reference the cell, if they are
blank, the text fields come up with a 0 and the dates are o-jan-00. I then
have to reformat each time. Is there a way to not have to reformat each
time. Return blanks, when they are blank.