P
PAL
I have 6 cells going across rows:
F2 is a text box
G2 is a date
H2 is a date
I2 is a text box
J2 is a text box
When I reference these cells:
if there is not a value in the text box to copy over, I get 0 in the "new
cell".
if there is not a value in the date box, I get 0-jan-00.
I have to reformat the new cells each time, which is a drag....Is there any
way to reference them and not have to reformat each time. That is, when they
are blank, not get the 0 for blank text and 0-jan-00 for the blank date.
Thanks.
F2 is a text box
G2 is a date
H2 is a date
I2 is a text box
J2 is a text box
When I reference these cells:
if there is not a value in the text box to copy over, I get 0 in the "new
cell".
if there is not a value in the date box, I get 0-jan-00.
I have to reformat the new cells each time, which is a drag....Is there any
way to reference them and not have to reformat each time. That is, when they
are blank, not get the 0 for blank text and 0-jan-00 for the blank date.
Thanks.