How do I format the data in Excel

[Viper535]

Example:
in VB, I created a Cell call rTotalCost
rTotalCost.Formula = "=Sum(A1:A20)"
and I want to format this Cell to Currency.

Thank you

 

[PlausiblyDamp]

Doesnt the cell have a .Format property?

 

[Viper535]

can you give the example how to format this?

Thank you

 

[PlausiblyDamp]

sorry you use the range object not the cell but something similar to

Range("a1").NumberFormat = "#,##0.00"

should work.

 

[Viper535]

Hi PlausiblyDamp,
Thank you for you help. I got it work....

Thanks alot