Adding Hyphens to Numbers in the Selected Area

An Excel file that teaches how to perform Adding Hyphens to Numbers in the Selected Area operation.

Excel Source: Adding Hyphens to Numbers in the Selected Area

The macro formats each value in the selected range. Numbers are divided into groups of four. The hyphen character is placed automatically. Cell text format is preserved. Incorrect entries are skipped.

Hope it is useful.