Excel rounds off large numbers. To stop Excel from rounding numbers, you have to convert numbers into text. Here is how to do that.

Permanently Disable Auto-Formatting If you're looking for a more permanent solution, Microsoft Excel allows you to disable auto-formatting for all your spreadsheets at once.