[Solved] 17-digit number entered in cell changes

Discuss the spreadsheet application
Post Reply
Eriksen
Posts: 2
Joined: Mon Apr 27, 2020 9:44 pm

[Solved] 17-digit number entered in cell changes

Post 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!
Last edited by MrProgrammer on Tue Apr 28, 2020 1:17 am, edited 3 times in total.
Reason: Tagged ✓ [Solved]; Moved topic from Beginners forum to Calc; Changed subject, was: Calc number entered in cell changes
Open Office 4.1.1 Windows 10 Pro
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Calc number entered in cell changes

Post 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
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Eriksen
Posts: 2
Joined: Mon Apr 27, 2020 9:44 pm

Re: Calc number entered in cell changes

Post by Eriksen »

That worked, thank you!
Open Office 4.1.1 Windows 10 Pro
Post Reply