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.


--


Gary


"Sundara Murthy" <(E-Mail Removed)> wrote in message
news067FC70-990E-4A94-BB25-(E-Mail Removed)...
>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

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

--


Gary


"Sundara Murthy" <(E-Mail Removed)> wrote in message
news067FC70-990E-4A94-BB25-(E-Mail Removed)...
>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

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

"Sundara Murthy" <(E-Mail Removed)> wrote in message
news067FC70-990E-4A94-BB25-(E-Mail Removed)...
> 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