How can I change the type of data

[Guest]

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

 

[Bill Martin]

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 Format>Cells
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
Tools>Macro>RecordNewMacro. Then set the formats manually as described above.
Finally, go back to Tools>Macro>StopRecording. 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

 

[Guest]

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: