Automation auto convert number text format into real number

[desmond_lee]

Hey guy

Why automation bot change my number formatted into text back to real number again? This cause my save form to get hang there when ai submit an TOOL AUDITOR ID. This column has a data format example 2264 or M165. Its a mix thus I select all to format type to text

See below table that column TOOL AUDITOR ID the submitted setting is Text but the add another row in the below tabale become pure number. 

The error in save the form