help on below

A

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.
 
V

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
 
Top