Forum Discussion
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.
larc91 I have the same issue. I have tried every solution found on a search, including deleting the content and editing the cell format to text. It then converts to scientific notation. I need the full number. The problem here is that I have thousands of numbers in excel and I don't really want to manually type all of them. Is there a better solution to stop excel from rounding my numbers?
- The easiest way to deal with this is to select the columns with a CTRL + Click, then right click and select "Format Cells". In the Format Cells menu, select "Custom" and enter a bunch of #################################, then click "Ok". This will convert all the numbers back to normal.
