• Background
    • Awards
    • Biography
    • Resume
  • Site
    • Blog
    • Cookie Policy
    • Galleries
      • Photo Gallery
      • Video Gallery
    • Glossary
  • Contact
    • Contact
    • Social Networks
  • IT
    • Downloads
      • Windows
    • Equipment
    • Hardware
    • Software
    • Testimonial
    • Information Technology
  • Projects
    • Business Projects
    • PC Projects
      • Hackintosh Laptop Projects
      • Hackintosh Desktop Projects
    • Website Projects
    • More Projects
  • Service Rates
    • Business Rates
    • Residential Rates

SSN in Excel Without Hyphens

Wednesday, November 28, 2012 Articles, Tips Comments Off on SSN in Excel Without Hyphens

If you are trying to save, update or create a column that lists a person or person’s SSN in Excel without hyphens or dashes, there is a simple way to do it which takes just a few seconds to do depending on your current knowledge of Microsoft Excel. This solution took me about an hour to figure it out for the Human Resources Department but during the troubleshooting, I learned about switching characters in Excel columns from the employee so it was not a waste of time.

https://www.youtube.com/watch?v=llGJBuUnRTI

Hiding/Masking the Hyphens
1. Launch a session of your version of Microsoft Excel.
2. Open your Spreadsheet that needs to be corrected
3. Click the top of the column to be used for SSN to highlight those rows.
4. Right-click the top column and then choose the option to Format Cells.
5. Select Special from the Category list.
6. Switch the language to Portuguese (Portugal).
7. Choose Social Security Numbers (Numero da Seguranca Social) from the type.
8. Confirm your changes and review your spreadsheet.

A bonus with this tip is that when entering a person’s Social Security number that starts with a zero, the zero will no longer be stripped from the information so 091123456 will not end up as 91123456.

Note: If you save the Spreadsheet as a (comma delimited) CSV file, the info will be stripped when reopened later in Excel so to see the information without stripping the data, please right click on the Excel file and edit/open it with Microsoft Notepad.

The following two tabs change content below.
  • Bio
  • Latest Posts
facebook-profile-picture
My Twitter profileMy Facebook profileMy LinkedIn profileMy Instagram profileMy Pinterest profileMy YouTube channel

Stephan Pringle

Technology Support Specialist at Sipylus
About The Author: Stephan Pringle is an Information Technology Support Specialist. He covers hardware and software and provides tips for you to troubleshoot and repair issues on your own. In his spare time, he writes articles about the State of New York on his Hackintosh and HackBook and that has helped him to become the top contributor of the New York City section of Yahoo! Answers.
facebook-profile-picture
My Twitter profileMy Facebook profileMy LinkedIn profileMy Instagram profileMy Pinterest profileMy YouTube channel

Latest posts by Stephan Pringle (see all)

  • Importing a PDF File to an Excel File - Saturday, August 19, 2023

Related posts:

  1. Switching Characters in Excel Columns
  2. Automatically Insert a Decimal Point
  3. Unable to Open .SYLK Files
  4. Looking Up Wi-Fi Passwords
  5. Sharing Information Online
  6. Your Uninstaller Pro
  7. Vanity URL for LinkedIn Profiles
  8. Internet Explorer Security Tool
  9. Recreate a Local Profile
  10. Spoofed: Server Update
  11. Password Security Best Practices
  12. Creating an Outlook Signature
  13. Microsoft Security Essentials
  14. Compress Multiple Files for Emailing
  15. Menu Bar in Internet Explorer
  16. Recreate a Network Profile
  17. Microsoft Word Force Exit
  18. Create an EFI Partition for macOS with Ubuntu
  19. Password Strength
  20. Microsoft Office Suite Tutorial

Comments are closed.




Copyright © 1990-2023 Stephan Pringle. All rights reserved.

The information contained on this website is for your personal use only.
It may not be reproduced in whole or in part, by any means, for dissemination without our written permission.

Stephan Pringle

Technical Support Specialist

  • Keyword Search

  • Topic Sponsor