Link cell between WS w/o dest display 0-jan if no entry at source
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
--
macropod
[MVP - Microsoft Word]
"Jack Miller" wrote in message
...
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
|