How to convert Text to Numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top