The field type Text should be chosen to ensure that leading zeros in the purchase order number are preserved. This is because text fields store alphanumeric characters as strings, and do not remove any leading or trailing characters. On the other hand, number, decimal, and serial fields store numeric values as numbers, and automatically remove any leading zeros when displaying or exporting the data123. Therefore, text fields are more suitable for storing data that needs to retain its original format, such as purchase order numbers, zip codes, phone numbers, etc. References:
Zeros at the start of a field appear to be omitted in Data Exports
Keep First ‘0’ When Importing a CSV File
Import and export address fields that begin with a zero or contain a plus symbol
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit