Hi,
I've been trying to figure this out for ages but can't work out how to do it.
Basically I've got a spreadsheet with 4 sets of numbers in it. What I need is for another 4 sets of cells to look at the data in the original cell and if it's a number, display that number, but if it's text, display 0.
Hope this makes sense.
TIA
I've been trying to figure this out for ages but can't work out how to do it.
Basically I've got a spreadsheet with 4 sets of numbers in it. What I need is for another 4 sets of cells to look at the data in the original cell and if it's a number, display that number, but if it's text, display 0.
Hope this makes sense.
TIA