Viper535 Posted November 25, 2003 Posted November 25, 2003 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 Quote
Administrators PlausiblyDamp Posted November 25, 2003 Administrators Posted November 25, 2003 Doesn't the cell have a .Format property? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Viper535 Posted November 25, 2003 Author Posted November 25, 2003 can you give the example how to format this? Thank you Quote
Administrators PlausiblyDamp Posted November 25, 2003 Administrators Posted November 25, 2003 sorry you use the range object not the cell but something similar to Range("a1").NumberFormat = "£#,##0.00" should work. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Viper535 Posted November 25, 2003 Author Posted November 25, 2003 Hi PlausiblyDamp, Thank you for you help. I got it work.... Thanks alot Quote
Recommended Posts