and 18 digit numbers. This apostrophe is not displayed in the cell but you can see it in the formula bar. After adding apostrophes, Excel has displayed the original value without rounding.

4 quick and easy ways to convert numbers stored as text to real numbers in Excel Your email has been ... you can see that these values are text and not stored as real numbers.