Converting input into a number

[walid66]

does anyone has an idea how to convert the values in this sheet to numbers. what's the best way to convert the values in the attached sheet to number using VBA code. if there is text in the row leave as text and convert the rest to numbers see attached sheet.

[ConneXionLost]

In C3 enter a "1" (without quotes).
Copy C3.
Select your range A1:A47.
Select "Paste > Special > Multiply".

Cheers,

[tom1977]

The faster way is:
Put for example in B1 value “1” then press CTRL + C (copy) then select column A and select past special (mark multiply) and You got what you want without VBA

[watersev]

hi, walid66, as an option, run code "test"

[walid66]

Thanks for your help. It worked like a charm.