add dash between numbers in Excel

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.

πŸ“ 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:

  1. Right-click on the column or cell containing Aadhaar numbers.
  2. Click on Format Cells.
  3. In the Format Cells window, go to the “Number” tab and click on Custom.
  4. In the Type field, enter: yamlCopyEdit0000-0000-0000
  5. 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!

Example:

Leave a Reply

Your email address will not be published. Required fields are marked *

Pinterest
Instagram