| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating Cells in VBA
How do I format a cell to be currency with VBA Code?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formating Cells in VBA
Goto Tools-macro-record macro
While macro is recording, select the cell, right click and select Format Cells..., from Category listbox select Currency, OK. Click'Stop' button to stop macro recording. Press Alt-F11, goto Modules and take a look at the code for Macro1 "Greg Bloom" wrote in message news:ldJbb.547825$Ho3.95541@sccrnsc03... How do I format a cell to be currency with VBA Code? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formating Cells in VBA
Range("Sheet1!C7:C17).NumberFormat = "$#,##0.00"
"Greg Bloom" wrote in message news:ldJbb.547825$Ho3.95541@sccrnsc03... How do I format a cell to be currency with VBA Code? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating cells | Excel Discussion (Misc queries) | |||
| formating cells | Excel Worksheet Functions | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| formating of certain cells not possible! | Excel Discussion (Misc queries) | |||
| Formating Cells | Excel Discussion (Misc queries) | |||
Linear Mode
