Avoiding "0" importing blank cells from another Excel file

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

Guest

When importing data from another Excel spreadsheet, you get a 0 where there
was a blank cell. Can this be avoided?
I tried to use If (B5=0," ",B5) which returns what looks like a blank cell,
but really isn't. This drives statistics insane - sees it as 0 since it
isn't a blank cell in reality.
How can I avoid these problems without going through and physically deleting
each 0? (find 0, replace with won't work since deletes any 0). I have
thousands of data points.
 
Jan said:
When importing data from another Excel spreadsheet, you get a 0 where there
was a blank cell. Can this be avoided?
I tried to use If (B5=0," ",B5) which returns what looks like a blank cell,
but really isn't. This drives statistics insane - sees it as 0 since it
isn't a blank cell in reality.
How can I avoid these problems without going through and physically deleting
each 0? (find 0, replace with won't work since deletes any 0). I have
thousands of data points.
Click to expand...

Ty "" instead of " ". Maybe that's not the problem. sorry

ed
 
You must log in or register to reply here.

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
Replacing blank cells with zeros 4
Question about conditional formatting of zeros in Excel 0
Graphing 0 values from blank cells 7
VLOOKUP returns 0 (zero) when lookup cell is blank 5
Formatting 0 values to show blank cells 4
Displaying zeros in cells 2
I hate the DIV/0! error! Can anyone help me make this go away? 5

Back
Top