How do I format a cell to keep 18 digit integers? The default rounds to 16 digits.
W W V Wright Feb 17, 2004 #1 How do I format a cell to keep 18 digit integers? The default rounds to 16 digits.
F Frank Kabel Feb 17, 2004 #2 Hi AFAIK you have to format the cell as text as Excel does not support 18 digit values. You my also have a look at http://www.big-numbers.com/ for an add-in to calculate with this kind of numbers
Hi AFAIK you have to format the cell as text as Excel does not support 18 digit values. You my also have a look at http://www.big-numbers.com/ for an add-in to calculate with this kind of numbers
