Convert text into numbers

[Frejo]

Hi all,

I've recorded a small macro that basically just formats an Excel-sheet into a format that I like to work with. The "raw" data is retrieved from a database. In this case Excel treats some data as text when it is actually numbers and I need to correct that. It is very easy to do manually but I would like my macro to do it for me. For some reason it's not possible to record this action and I can't seem to find a code snippet or other explanation that works for this particular issue.

Any help on this would be greatly appreciated. I have attached an example.

[MarMo]

You probably need to set the copied data into the format you want.

To set a column into a number format, you could use this kind a of code

Please Login or Register  to view this content.

or in the specific cell :

Please Login or Register  to view this content.

You'll need to look up the different possibilities in formatting.

[Frejo]

Thanks for the tip, however it doesn't work in this case. It now shows as "Number" on a cell, but Excel still gives you the exclamation mark and says "Number stored as text".

[jindon]

Try

Please Login or Register  to view this content.

[MarMo]

jindon,

you beat me to it

This was the code i was going to upload.
first is for the activecell , the other for a column.

Please Login or Register  to view this content.

[Frejo]

It works great, thanks for the support jindon and MarMo.

//Fred