check for cell with numeric value

[SteveW]

I have a function to append/alter a cell depending on it's contents
Is there an easy way to determine cell has a numeric value rather than text
....cell.Value > 0 returns true even if cell has Text in it

 

[Guest]

if isnumeric(cell.value) then

 

[SteveW]

Works in my function perfectly

Thanks

Steve