Linking Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When linking cells from one tab to another, where the cell from the source
cell is blank, the return value shows a 0. How can I get that to be blank as
well? Same issue with dates, when the source cell is blank, the date returned
is 1/1/1900. I need a blank there as well.
 

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

Excel formula, sum the value cell and if empty cell left blank 0
Please help! date showing as 1900/01/00 2
Help needed 0
IF date not blank 5
if function and date 2
Leaving a formula cell blank when data has not yet been added. 5
If formula Date not Blank 2
Using COUNTA and excluding formulas that gives zero or blank cells 3

Back
Top