I am wanting to format 3 columns of data in the comma style like I would if I used the Alt+H+K shortcut would format. Instead I cannot find any method that works. I have used "#,###.##" & "Comma" and still the values do not look at all like they would if I used the comma icon on the Home ribbon.
Here is my code:
Worksheets("AUC").Range("L:N").numberformat = "#,##.##"
Here is my code:
Worksheets("AUC").Range("L:N").numberformat = "#,##.##"