QP School › Tutorials › Excel VBA Tutorials v
How to format an entire column as number with thousand separator in Excel VBA

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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
#1
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
Reply


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 388 07-27-2023, 11:23 AM
Last Post: Qomplainerz
  Calculate factorial of a given number in VBA Qomplainerz 0 388 07-27-2023, 11:04 AM
Last Post: Qomplainerz
  Calculate the sum of values in a column with VBA Qomplainerz 0 358 07-27-2023, 08:18 AM
Last Post: Qomplainerz
  Format cells with conditional formatting in VBA Qomplainerz 0 357 07-27-2023, 08:16 AM
Last Post: Qomplainerz
  Calculate the factorial of a number with VBA Qomplainerz 0 359 07-27-2023, 07:56 AM
Last Post: Qomplainerz
  Count the number of rows in a worksheet with VBA Qomplainerz 0 322 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 456 04-13-2023, 12:26 PM
Last Post: Qomplainerz
  How to select an entire column in Excel VBA Qomplainerz 0 392 04-13-2023, 12:03 PM
Last Post: Qomplainerz
  How to select a particular cell in Excel VBA Qomplainerz 0 399 04-13-2023, 12:02 PM
Last Post: Qomplainerz

Forum Jump:


Users browsing this thread: 8 Guest(s)