VBA Code to format a column to a specific number format

**TreeLife** · 11-24-2018, 01:38 PM

Hi,

I am looking for help with a vba code to take numeric data in a specific column and auto adjust to a number format to show like:

$1,000 ($1,000)

However if you click in the cell it shows the number rounded the number to 2 decimals places only. So that is what's detected by formulas dependent on the cells.

Thank you.

**xladept** · 11-24-2018, 02:36 PM

Something like:

Please Login or Register  to view this content.

**Mumps1** · 11-24-2018, 02:36 PM

Change the column to suit your needs.

Please Login or Register  to view this content.

**Fluff13** · 11-24-2018, 02:45 PM

If you want to round to 2 decimals as well try

Please Login or Register  to view this content.

**xladept** · 11-24-2018, 09:26 PM

Thanks for the rep!

VBA Code to format a column to a specific number format

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to format a column to a specific number format

Re: VBA Code to format a column to a specific number format

Re: VBA Code to format a column to a specific number format

Re: VBA Code to format a column to a specific number format

Re: VBA Code to format a column to a specific number format

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

[SOLVED] Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

vba code to format a column to a specific format (SSSS X1111111)

Need formula or code to convert number(s) from custom format to number format

Custom number format code for hiding specific values on chart axes

How to format percentage column as a number format

[SOLVED] Format a column wihtout using "Format-Cells-Number-category-etc"

Bookmarks

Bookmarks

Posting Permissions