Skip to main content
Topics#Customer ServiceMatt Brown's Question
Matt Brown (Appirio) asked in #Customer Service
Feb 12, 2010, 2:34 PM

Importing Leading Zeros affecting updating records with Case Number

Actually the issue is that we have recently been told by SFDC Support that Salesforce cannot accept number imports with leading zeros. Obviously this affects any import we do to insert or update the Case Number on any given objects where there is a Case Number. 

 

Our current Case Number starts with triple zero. The solution was to export and re-import all Cases with a letter prefixing the Case number. 

 

Does anyone have any other solution?
4 answers
  1. John Kucera (Salesforce)
    Feb 12, 2010, 9:47 PM
    If you just want to get rid of the zero's pre-import, you can use:

     

    =Int(A1)

     

    in Excel to remove the zero's before importing. 

     

    Assuming you are using lookup fields for Case Number on the other objects, that "Number" is auto-updated when the Case Number on the Case is updated.
Write an answer...
0/9000