Only follow formulas with values???

[StevieP]

Is there a way to specify that a command is only followed through if there is a value?

I'm trying to get one spreadsheet to read another and place the values into a table as they are put into the original spreadsheet but at the moment it is reading the blank cells as '0', whereas I want it to remain empty until the original cell has a number... if that makes the slightest bit of sense???

[sweep]

Hi,

To test if the cell contains a number or not, you could use

=IF(ISNUMBER(A1),"Value if it's a number","Value if it's not a number")

[StevieP]

Brilliant, thanks a lot. That's solved my problem