Macro - Convert stored text to number

[adste89]

Hello Again,

My macro currently pulls in information from an SQL database but when it does that, all the numbers in column A need "converting to number".

Is there a way to convert all cells in column A to number as a part of my macro?

Currently I have to go to the error checking box and click "convert to number".

Thanks for any help!

Adam

[Norie]

Adam

What macro?

You haven't posted any code.

[:) Sixthsense :)]

Just use Text To Column>>Delimited>>Next>>Under Delimiters Don't Check any thing>>Next>>Finish.

[adste89]

Hi I didn't post any code because I would just want the macro that would convert text to numbers to add onto the end of my code.

I can convert it using text to column etc but that is a manual input...it needs to be automated...

[:) Sixthsense :)]

Just use Record Macro and select the column and follow the steps then you will get the piece of code and add that piece in your code.

[apo]

Hi..

You could do this..

If you have no blank rows in A..

Please Login or Register  to view this content.

or this..

This is just automating the task of paste special - Multiply by 1..

Please Login or Register  to view this content.

[adste89]

thanks the last one would be better as it will have blanks in...what do you mean "multiply by 1"?

[AB33]

Untested, try it

Please Login or Register  to view this content.

[apo]

Hi..

One way of converting text to numbers is to do this:

1. Type the number 1 in a cell.
2. Right click on that cell and copy.
3. Highlight your cells that you want converted..
4. Right Click > Paste Special> Select Multiply

So the code i gave you is just automating that..