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

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

Hey thanks a lot. The real thing is that I'm progamin in a spreadseeht in one
of my outlook forms, That why the only way to change is in an opem event done
with a script. You just teach me the solution to most of my problems,
especially because all the codes are in english and my programs are in
portuguese.

"Bill Martin" escreveu:

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