How to convert Text to Numeric

[Guest]

I am storing the data like

SlNo Inv_No Date Amt
1 101 01-Nov-06 15000
2 101 01-Nov-06 20000
3 201 01-Nov-06 60000
4 301 01-Nov-06 70000

Now i am storing the inv_no as text field now i need to convert into numeric
in vba

 

[Gary Keramidas]

you could just copy the range, find an empty range, choose pastespecial, select
add under operation and click ok. then just copy and paste that range over your
original.

 

[Gary Keramidas]

oh, and make sure the original cells are formatted accordingly.

 

[NickHK]

Sundara,
If this is just a one time thing;
- Enter a 1 in a spare cell on the WS.
- Copy
- Select the inv_no range to change
- Paste Special > Multiply

If you record a macro of the above steps, you will get the code, so you can
run it again.

But do these inv_no entries really have any meaning as numbers ?
i.e. does "inv_no * 10" mean anything ?
To me, these should be text.

NickHK