How to format an entire column as number with thousand separator in Excel VBA

Thread Rating:

How to format an entire column as number with thousand separator in Excel VBA

Qomplainerz Offline

Administrator

Posts: 4,488
Threads: 4,488
Joined: Aug 2020
Reputation: 0

04-13-2023, 12:25 PM

Assumed you have created a module and a subroutine already, write the following code:

Range("A:A").Select
Selection.NumberFormat = "#,##0"

Also follow me on Youtube for videos about video games:
https://www.youtube.com/channel/UCxfkGVU...2mQ/videos

Find

« Next Oldest | Next Newest »

Messages In This Thread

How to format an entire column as number with thousand separator in Excel VBA - by Qomplainerz - 04-13-2023, 12:25 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Format cells in a range with bold font and yellow background color	Qomplainerz	0	772	07-27-2023, 11:26 AM Last Post: Qomplainerz
	Autofill a series of numbers in a column	Qomplainerz	0	390	07-27-2023, 11:23 AM Last Post: Qomplainerz
	Calculate factorial of a given number in VBA	Qomplainerz	0	389	07-27-2023, 11:04 AM Last Post: Qomplainerz
	Calculate the sum of values in a column with VBA	Qomplainerz	0	360	07-27-2023, 08:18 AM Last Post: Qomplainerz
	Format cells with conditional formatting in VBA	Qomplainerz	0	359	07-27-2023, 08:16 AM Last Post: Qomplainerz
	Calculate the factorial of a number with VBA	Qomplainerz	0	360	07-27-2023, 07:56 AM Last Post: Qomplainerz
	Count the number of rows in a worksheet with VBA	Qomplainerz	0	327	07-27-2023, 07:50 AM Last Post: Qomplainerz
	How to format an entire column as number without thousand separator in Excel VBA	Qomplainerz	0	459	04-13-2023, 12:26 PM Last Post: Qomplainerz
	How to select an entire column in Excel VBA	Qomplainerz	0	396	04-13-2023, 12:03 PM Last Post: Qomplainerz
	How to select a particular cell in Excel VBA	Qomplainerz	0	402	04-13-2023, 12:02 PM Last Post: Qomplainerz

Forum Jump:

Users browsing this thread: 2 Guest(s)