[Solved] 17-digit number entered in cell changes

Discuss the spreadsheet application

[Solved] 17-digit number entered in cell changes

Postby Eriksen » Mon Apr 27, 2020 10:00 pm

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
Eriksen
 
Posts: 2
Joined: Mon Apr 27, 2020 9:44 pm

Re: Calc number entered in cell changes

Postby MrProgrammer » Mon Apr 27, 2020 10:34 pm

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 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3959
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Calc number entered in cell changes

Postby Eriksen » Mon Apr 27, 2020 11:08 pm

That worked, thank you!
Open Office 4.1.1 Windows 10 Pro
Eriksen
 
Posts: 2
Joined: Mon Apr 27, 2020 9:44 pm


Return to Calc

Who is online

Users browsing this forum: Majestic-12 [Bot] and 21 guests