converting text to numbers in vba

**shekar goud** · 04-20-2009, 08:14 AM

Hi Team,

How can i convert text columns to numbers in VBA.

Could someone advise how to do this.

Regards,
Shekar.

**mudraker** · 04-20-2009, 08:34 AM

If I understand you correctly this is one way
It displays the result in a message box

Please Login or Register  to view this content.

**royUK** · 04-20-2009, 08:38 AM

Originally Posted by mudraker

If I understand you correctly this is one way
It displays the result in a message box

Please Login or Register  to view this content.

I think you need to explain more clearly. Do you mean convert numbers stored as text to numbers?

**vikas.bhandari** · 04-20-2009, 08:40 AM

I tried the following funda, and it worked pretty fine for me. If it doesnt, then let me know the exact thing you are trying to do.

Please Login or Register  to view this content.

Thanks,
Vikas

**shekar goud** · 04-20-2009, 09:05 AM

Hi All,

Thanks for all your response.

I just wanted to convert column "D" into numbers where i have numbers.When i trimed the column it converted into text problem is i have to vlookup that row which is giving #N/A.

Regards,
Shekar.

**NBVC** · 04-20-2009, 09:13 AM

Perhaps you can record a macro.

After initiating the recording, select the column and go to Data|Text to Columns and click Finish.

Stop the macro.

Now you have a macro that you can attach to a button.

If it is a rare use thing, it's just as easy to simply do the actions manually rather than have a macro...

**shekar goud** · 04-20-2009, 09:29 AM

Hi All,

Thanks again i have done this at the first i got the below.

Please Login or Register  to view this content.

when i did this as per your advise its wonder its worked really thanks to all.

Please Login or Register  to view this content.

It would be great if some guide me how do Vlookup with another file.

Regards,
Shekar.

**NBVC** · 04-20-2009, 09:33 AM

It would be great if some guide me how do Vlookup with another file.

You should post this question with examples etc, in a separate thread in the Excel Worksheet Functions forum.

**NBVC** · 04-20-2009, 09:47 AM

Also please mark this thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save