help on below

[Ashish]

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.

[VBA Noob]

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