Am trying to put the number 20127019035143 into a cell, but it comes out as : -2.01270E+013.
I have selected Numbers in Format, what am I doing wrong?
johnoo wrote:Am trying to put the number 20127019035143 into a cell
John_Ha wrote:johnoo wrote:Am trying to put the number 20127019035143 into a cell
Be aware that 14 digits is very close to the limit of integers supported by Calc.
Also, neither integers nor floating point numbers can have a resolution of more than about 15 digits. Any digits over 15 are ignored or set to zero and do not take part in calculations.
Calc suggests you can display 20 digits but that is wrong.
johnoo wrote:Thanks, I wanted a 14 digit number, just happens to be my Library card number!
John_Ha wrote:johnoo wrote:Thanks, I wanted a 14 digit number, just happens to be my Library card number!
Pedantically, it is a label and not a number to be calculated, so should really be stored as a 14 character string and not as a number.
johnoo wrote:So, how in Calc, do i store it as a 14 character string?
Do I have to change a setting in Format?
John_Ha wrote:johnoo wrote:Thanks, I wanted a 14 digit number, just happens to be my Library card number!
Pedantically, it is a label and not a number to be calculated, so should really be stored as a 14 character string and not as a number.
See Solved] Import 20-digit ICCID numbers from CSV
Users browsing this forum: No registered users and 16 guests