Scientific notation can be a display choice, but a long identifier may also have been interpreted as a number and changed. Check the source before attempting a cosmetic repair.
Compare the exact original
Select the cell and inspect its formula bar. Compare every character with the authoritative ID. Widening the column or changing number formatting can reveal a different display, but it cannot recover digits already lost during numeric interpretation.
Do not use arithmetic or approximate comparison to establish identifier equality. An account number is a key, not a quantity whose small rounding difference is acceptable.
Preserve the field as text
Prepare the destination with Format > Number > Plain text before entering or importing long IDs. Reimport from the authoritative source if earlier conversion altered the value.
For API-based entry, choose an input method that preserves a string as a string rather than relying on user-entered parsing. Confirm the actual JSON type as well as the selected input option; a numeric payload may already have lost information before it reaches Sheets.
Verify the entire transfer path
Test zero-prefixed IDs and long values differing only near their end. Compare exact strings after saving and after export. Check the receiving application’s own import behavior, since it can reinterpret text again.
Keep raw source fields and record-level reconciliation until the transfer is validated. A custom numeric mask can change appearance but does not make a numeric identifier text. Document the field’s required representation for future imports so another editor does not apply Number formatting and reintroduce the problem.
References
- Format numbers in a spreadsheet
- Edit & format a spreadsheet
- ValueInputOption | Google Sheets | Google for Developers
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.