| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I use VBA to format a column to currency
I'm trying to use code to force the entire column to be currency. I also
have another column I'm trying to force to text, any help is appreciated |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can I use VBA to format a column to currency
Columns(3).Numberformat = "$#,##0.00"
Columns(4).NumberFormat = "@" -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "SITCFanTN" wrote in message ... I'm trying to use code to force the entire column to be currency. I also have another column I'm trying to force to text, any help is appreciated |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can I use VBA to format a column to currency
Use the macro recorder while you format the column manually. That should
give you the start you need. Regards Trevor "SITCFanTN" wrote in message ... I'm trying to use code to force the entire column to be currency. I also have another column I'm trying to force to text, any help is appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
| Column with currency & text - how to format? | Excel Discussion (Misc queries) | |||
| Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) | |||
| Conversion from currency value to currency text format | Excel Programming | |||
Hybrid Mode
