Number stored as text

I know this has been covered numerous times but I'm gonna kick this dead horse...

I have a column filled with about 1000 numbers which should be stored as Currency, but that pesky green triangle is still there, When I transfer these numbers to another sheet to calculate the selling it will not calculate, because......... the number is stored as text!

The only way I can fix this is if I double click the cell and push enter, and I'm sorry, call me Lazy, but im not going through a list of 1000 numbers double clicking every one of them...

My question is can anyone come up with a simple solution for this? I would prefer a VBA based solution if possible...

Open a new workbook and copy a blank cell
Highlight the range of cells you need to change and select "Paste Special"
When that window opens, click in the radio button next to "Add" and press OK.

It will add zero to each of the numbers (i.e. wont change the figures at all) but will automatically turn them all into number format.

No VBA needed.

Ok I tried this multiply thing before and i didn't work, now it does... I don't get it oh well it works now... When I use this method it takes all the formatting away from the header row so I had to go back and fix this heres what the recorder made for me...

Thank You for the help!

Please Login or Register  to view this content.

Works Great! Thanks A Lot!

Thanks that was such an easy solution! I just had to unmerge some cells first and it worked perfectly - and thanks muddbog for kicking a dead horse!