• Background
    • Awards
    • Biography
    • Resume
  • Blog
    • Technical Support 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)

  • HP Color LaserJet Pro MFP M477fdw - Friday, April 14, 2023

Related posts:

  1. Looking Up Wi-Fi Passwords
  2. Vanity URL for LinkedIn Profiles
  3. Automatically Insert a Decimal Point
  4. Sharing Information Online
  5. Password Security Best Practices
  6. Say Farewell to Orkut
  7. Spoofed: Last Warning!!!
  8. Password Strength
  9. Internet Explorer Security Tool
  10. Menu Bar in Internet Explorer
  11. Microsoft Office Suite Tutorial
  12. Usernames for cPanel Accounts
  13. McAfee Security Scan Plus
  14. Locate The Recycle Bin
  15. Spoofed: Login from New Computer
  16. Disable AdBlock
  17. Removing the McAfee Agent
  18. Creating an Outlook Signature
  19. Disable uBlock Origin
  20. Switching Characters in Excel Columns

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