help on below
 

hi,

i need help to look value in the particular cell which contains both numbers
and text or may be just numbers. if it contains numbers and text thn pick the
number and multiply by 10 and if just number than display the current number
in it.

help on below
 

Would be useful to post an example of length of text and if there's any
patten.

The easy bit is working out if it's a number

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=565813