Forum Discussion
Solved
Keeping exact numbers (stop rounding/scientific notation)
I have one column that lists various receipt IDs that include a variety long or short numbers or text (Example: 3666979/JU; 20001010905018546; R00017/2020; 16773...). I just want to keep the exact nu...
Try it in this order:
1. Delete current cell content.
2. Change number format to "Text".
3. Type the ID into the cell.
Try it in this order:
1. Delete current cell content.
2. Change number format to "Text".
3. Type the ID into the cell.