Referencing Cells on Another Sheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top