Hi Darin,

Try this ( Puts a BLANK if it is TEXT ) :-

=IF(ISNUMBER(A1),A1,"")

All the Best.
Paul



From: Darin Kramer

Thanks, works perfectly

Do you perhaps know how to say if cell A1 is text, then ignore, if its a
number then multiply by 1.
(I need to run only on numbers not on text that is within the sample..)




*** Sent via Developersdex http://www.developersdex.com ***