Blanks in spreadsheet

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

Guest

Hi
I have a source spreadsheet which is dynamically linked to a target
spreadsheet using paste link option. But all the blanks in the source as are
appearing as 0s which I want as empty cells. How can I do this.

2.Can I do fill series on links in my target xls? I tried it currently but
it errors as the values are link address and not text or numbers.

Please inform.

Thanks
Bob
 
Test it in the link

=IF(Target!A1="","",Target!A1)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

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

blank cell return vs. a 0 8
HELP!!!!!!!!! 2
Linking spreadsheet 1
#N/A In Cells 7
formula problem 1
formula finds values in apparently blank cells 1
Linked sheets, blank cells and adding new rows 1
error with countif formula on when adding linked spreadsheets 0

Back
Top