Hi All,
I need to save a value into a certain cell, formatting it as currency with 0 decimal places. How do I do this?
I know of the Format function, but don't know how to control the decimal places.
-
Activesheet.Cells(1,2) = Format(ListPrice,"currency")
-
I cannot pre-format the cell using the Excel menu because my code requires all cells in the worksheet to be Cleared (Using "Clear All") before this statement. I'd really applreciate any help on this. Thanks!
Manish
I need to save a value into a certain cell, formatting it as currency with 0 decimal places. How do I do this?
I know of the Format function, but don't know how to control the decimal places.
-
Activesheet.Cells(1,2) = Format(ListPrice,"currency")
-
I cannot pre-format the cell using the Excel menu because my code requires all cells in the worksheet to be Cleared (Using "Clear All") before this statement. I'd really applreciate any help on this. Thanks!
Manish