Cells having social security number formats gets trimmed while importing RRS feed

  • Question

  • We have social security number(SSN) column in our .xlsx file.We are having SSN values starts with zero.So we are entering SSN values start with zero into the column and applying social security number format.When we importing .xlsx file in our application,we are getting trimmed SSN values.It removing zero from SSN values which starts with zero.So could please help on this issue.

    For example:

    We are entered '012-34-5678' SSN Value and while importing we are getting '12345678' SSN value

    Wednesday, April 12, 2017 10:21 AM

All replies

  • A lot depends on your 'application' but try saving the file as a .csv, which will contain the correctly formatted SSNs.  You could also try changing from SSN format to text format, and enter   012-34-5678  (with the dashes) - otherwise, you may need to adjust how your application reads the XL file. 

    Wednesday, April 12, 2017 5:06 PM
  • Hi AJ_27,

    If SSN is in column [A], select [A] and make its Format number [Text].
    This is manual way.

    Modify/add code in your application as it does the above.
    I suppose it would be easy.
    • Edited by Ashidacchi Friday, April 14, 2017 12:35 AM
    Friday, April 14, 2017 12:32 AM