Add Hyphens to Numbers in a Selected Field

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

Excel Source: Add Hyphens to Numbers in A Selected Field

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.