[Solved] Number Format Problem

[johnoo]

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?

[Hagar Delest]

Enlarge the column?
Else, try to set the number of decimal places to 0 to force the number format.

[johnoo]

Great! Enlarged column now OK, thanks

[John_Ha]

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 or 16 digits. Any digits over 15 or 16 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]

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.

Thanks, I wanted a 14 digit number, just happens to be my Library card number!

[John_Ha]

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

[johnoo]

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.

So, how in Calc, do i store it as a 14 character string?
Do I have to change a setting in Format?

[John_Ha]

So, how in Calc, do i store it as a 14 character string?
Do I have to change a setting in Format?

Format > Cell > Text. Note that by default text strings are left justified and numbers are right justified.

[johnoo]

John Thanks, will remember in future (I hope)!

[RoryOF]

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

Also, looking like numbers, but actually labels, are zip codes, credit card numbers, phone numbers, bank account numbers - one does not (in general) do calculations using these.