Bob understand you <g


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi tvkodde26

If I understand you correct this will work for you?

Columns("A").NumberFormat = "General"




--
Regards Ron de Bruin
http://www.rondebruin.nl


"tvkodde26" wrote in message oups.com...
I need help in creating a macro that will repeat an easy command. I
have Column A full of numbers, some are formatted General and others
are formatted Text. For Vlookup purposes I need them all formatted as
General.

How would I build a Macro that goes to cell A1 and complete (Enter +
F2) to convert it to general and then it moves to cell A2 and repeats
the same command, etc.....

Thanks for any help.

Travis