MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linked Cells

Posted by Matthew Schmitt on May 10, 2001 1:50 PM

I have a sheet that pulls cells from another sheet. On the sheet I am pulling from, there are some cosmetic text lines, which I don't need in the other sheet, but can't get rid of on the original sheet. Is there a way to tell Excel to only display numeric values from the range that I have linked?

Posted by Dave Hawley on May 10, 2001 1:52 PM

Hi Matthew

have you looked at the ISNUMBER function ?

OzGrid Business Applications