Link cell between WS w/o dest display 0-jan if no entry at source

G

Guest

How can I link a date formatted entry from a source worksheet cell to a
destination cell in another worksheet without it resulting with (0-jan); when
there is no date entered at the source cell? If the source is blank, I would
like the destination to be blank as well. Seems like this would be a common
request, but I sure can't figure it out. EXCEL 2003

Thanks,

Jack
 
M

macropod

Hi Jack,

The simplest way is via Tools|Options|View and unchecking 0 values. This
suppresses all 0 values, which might be going too far. If it is, you need a
formula along the lines of:
=IF(Sheet1!A1=0,"",Sheet1!A1)

Cheers
 

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

Similar Threads

Default display of sample date in linked workbook with blank date in source cell 2
If Cell is Blank (Though a Link), Hide Result, Else Normal Font 5
display first or second match instead of #REF in INDEX ROW formula 9
Repeating entries without "0" if no entry 1
Chronological Date Orders 2
Date sensitive calculation refresh 6
Need Help with Cell Manipulation 2
Entering a date results in a decimal fraction 2

Top