felipe wrote:
I have a spreadsheet that I wnat to change the type of data in a colun. I'm a
beginer in scriping, but I had allready done some. My problem is simple I
want a colum to have the corrency type data and there is another one that I
want test. Sorry If my english is not clear, it is not my first language.
thanks

------------------------------

You can do it directly by highlighting that column, the going to FormatCells
and selecting the type of formatting you want.

If you want to see how to use a VBA macro to do this, then just go to
ToolsMacroRecordNewMacro. Then set the formats manually as described above.
Finally, go back to ToolsMacroStopRecording. At this point you can go into
the VBA editor and look at the macro that Excel created for you as an example.

Good luck...

Bill