Convert Text to a Number - VB Code Needed

Hello,

I some information on an excel spreadsheet that has numbers formated as text. I can not convert them to numbers unless I hit the explanation point beside the text number. I want to do this with visual basic code, but the macro will not pick up me clicking the explanation point beside the numbers. Does anyone know the code to do this????

If the number formatted as text is in A1, you could use:

Please Login or Register  to view this content.

to convert the text to a number.

HTH

Jason

Can you do a range of cells with this formula?? How would you do that

I figured out the code for this but it looks much larger. I recorded a macro under selecting Data then doing Text To Columns, and it did what I needed it to. The code is long though.

Try this for column A:

Please Login or Register  to view this content.

HTH

Jason

Glad it helped.

As with most VBA code when you use the recorder, there is a lot of unnecessary junk in there.

Jason

Yes, it had a lot of junk in it. I was able to cut down yours a little too. I took the array part out and it seemed to work. Thank You Jason!!!

As long as you're converting the text to General format, then you are correct, the FieldInfo can be left out. But if you were trying to convert to text, date, etc., you need that in there to let Excel know which format you need.

Jason