If you’re working with large numbers like Aadhaar numbers, phone numbers, or ID codes in Excel and want to insert a dash (-) automatically after specific digits, follow this simple trick using Custom Formatting.
Table of Contents
π Example:
You have a list of names and their Aadhaar numbers in this format:
123456789012
And you want to format it like:
1234-5678-9012
π Step-by-Step Guide:
- Right-click on the column or cell containing Aadhaar numbers.
- Click on Format Cells.
- In the Format Cells window, go to the “Number” tab and click on Custom.
- In the Type field, enter: yamlCopyEdit
0000-0000-0000
- Click OK.
Thatβs it! Your numbers will now automatically display with dashes after every 4 digits.
β Important Note:
- This method doesn’t change the actual value in the cell β it just changes how it’s displayed.
- Perfect for Aadhaar, credit cards, or formatted IDs.
Use this formatting trick to make your Excel sheets look professional and easier to read!