IF the number is always the right two digits, you could use this formula in
column B to modify column A where you type

=RIGHT(A1,2)*1

--
Best Regards,

Luke M


"FABIOZ28" wrote:

I would like to know what can i do to convert a Text in a number I want. What
is the formula for this?, cause I can't find it. For Example:

Convert "VA-30" in the number "30", and that everytime I write that text, in
the cell beside appears 30