Page 1 of 1

[Solved] 17-digit number entered in cell changes

PostPosted: Mon Apr 27, 2020 10:00 pm
by Eriksen
Hello, I'm using Calc, entering a 17 digit number into a cell. No decimal, no letters, only numbers. It changes the last two numbers to 00. I've tried Format Cells, have tried several different things but nothing works. I would think it should be Category Number, Format General. Any suggestions? Thank you!

Re: Calc number entered in cell changes

PostPosted: Mon Apr 27, 2020 10:34 pm
by MrProgrammer
Hi, and welcome to the forum.

Eriksen wrote:I'm using Calc, entering a 17 digit number into a cell. … It changes the last two numbers to 00.
[Solved] How to change the zeros at the end of long numbers
If you don't need to do arithmetic with the value, you can store it as text.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

Re: Calc number entered in cell changes

PostPosted: Mon Apr 27, 2020 11:08 pm
by Eriksen
That worked, thank you!