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 ***