SSAN -first digit is zero

[a_rosenbaum_(Guest)]

I have imported a spreadsheet file with a field of social security numbers.____Unfortunaely if the first number is zero it doies not show____Is there a formula to ad the zero if this condition exists.____Thank you

[kfleming]

What data type does this field come in as in R&R?__The answer to the question depends on the datatype.______Kathleen__R&R Support

[John_McDonald_(Guest)]

if the field is numeric ____if(field<100000000,"0"+str(field,8,0))____if the field is a character (assuming the field length is 9 characters)____if(left(field,1)=" ","0"+substr(field,2,8),field)____Hope that helps.____