Excel Quickie 19 - Store Huge Numbers the Right Way in Excel without Losing Digits

2 Simple and fast ways to ensure that Excel stores all of the digits that you enter for a very long number - this trick is needed because, by default, Excel will truncate your numbers (cut-off the end) when they get too long.

Both methods shown here work really well for quickly inputting the numbers so that they will never change after you hit Enter, regardless of the length of the number.

Enjoy!