P
PAL
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.
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.