CRT-101 · Question #73
An administrator has been asked to change the data type of an auto number to text field. What should the administrator be aware of before changing the field?
The correct answer is A. Existing field values will remain unchanged. When you change an Auto Number field to a Text field in Salesforce, existing values are preserved as-is - they simply become text strings instead of system-generated numbers. Salesforce retains the data during this specific field type conversion, so nothing is lost or…
Question
An administrator has been asked to change the data type of an auto number to text field. What should the administrator be aware of before changing the field?
Options
- AExisting field values will remain unchanged.
- BExisting field values will be Converted.
- CExisting field values will be deleted.
- DExisting auto number field to Text is prevented.
How the community answered
(23 responses)- A87% (20)
- B4% (1)
- D9% (2)
Explanation
When you change an Auto Number field to a Text field in Salesforce, existing values are preserved as-is - they simply become text strings instead of system-generated numbers. Salesforce retains the data during this specific field type conversion, so nothing is lost or transformed.
Why the distractors are wrong:
- B (Converted) is wrong because the values don't change format or content - a record that showed "00001" still shows "00001," now stored as text rather than an auto number.
- C (Deleted) is wrong because Salesforce never silently deletes field data during a supported field type conversion.
- D (Prevented) is wrong because this specific conversion is allowed; Salesforce does block some conversions (e.g., text to number when non-numeric data exists), but Auto Number → Text is permitted.
Memory tip: Think "Auto Number → Text is a safe one-way street." The data travels intact because every number is already representable as text - there's no lossy transformation possible, so Salesforce allows it and keeps all values unchanged.
Topics
Community Discussion
No community discussion yet for this question.