How to add the suffix to assignment number via Spreadsheet automatically

Summary:

How to add the suffix to assignment number via Spreadsheet automatically

Content (please ensure you mask any confidential information):

Hi !

I'm trying to create HCM Spreadsheet to import newhire

EE number is 45678 , their assignment number would be E45678.

But when i assign numbers manually system notice The assignment number already exists. Enter a unique assignment number

There are no employees in the system so this assignment number cannot already exist.

How to add the suffix to assignment number E45678 via Spreadsheet automatically

Note: If I set it to automatically follow the employee code, the system imports successfully

Version (include the version you are using, if applicable):