+- QP School (https://qomplainerzschool.lima-city.de)
+-- Forum: Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=3)
+--- Forum: Excel VBA Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=48)
+--- Thread: How to format an entire column as number with thousand separator in Excel VBA (/showthread.php?tid=5018)
How to format an entire column as number with thousand separator in Excel VBA - Qomplainerz - 04-13-2023
Assumed you have created a module and a subroutine already, write the following code:
Range("A:A").Select
Selection.NumberFormat = "#,##0"