Formatting of cell in VBA

[Ctech]

Very simple question probably, but didn't find a solution by Googleing

If there is a shortcut in Excel for this please let me know... but if not I'd like to create a custom macro to do this for me..

Format the active range or cell to number format with "1000 seperator" and no decimal points

[Andrew-R]

This macro will do that, and you can assign a short-cut key to it if you want to make it easy to run.

Please Login or Register  to view this content.