Convert Text-Formatted Numbers To Number Format

i dont have a macro for you, but just FYI you could multiply by 1 in the vlookup to convert to a number or use value(cell)

Hi accell,

I agree with etaf above. This is a VERY Cool thing in Excel. You can convert all those Text Numbers (with green corners) to numbers by doing the following. In any blank cell type a 0 (zero) and then copy the zero into the windows clipboard using either a Right Click and Copy or Ctrl-C. NOW with the zero in the clipboard....

Select all the cells you want to convert to text and then Right Click in the selected region. NOW do a Paste Special and look at the dialog. Click on the "ADD" radio button and then OK. This will add Zero to all the cells in the selected region, and convert them to numbers. NO VBA needed. See:
http://www.dummies.com/how-to/conten...xcel-2010.html for some pictures on how to do this.

Note etaf wanted to multiply by 1 and I liked to add zero. Either will get the same result.