[Solved] How to change the zeros at the end of long numbers

Discuss the spreadsheet application

[Solved] How to change the zeros at the end of long numbers

Postby commonman123 » Thu Nov 17, 2011 3:39 pm

Hi there, first question on this board, hope someone can help! ^^

I'm doing a project for my math class involving very large numbers, but they're NOT supposed to be written in scientific notation, but in standard form instead. I noticed though that any number after the 16th digit is instead replaced with a zero. Kind of an annoying auto feature, seeing how I don't want those extra numbers rounded off like that. Is there a way to keep the original number? For example, 2^64 is supposed to be 18,446,744,073,709,551,616. That's the number I want displayed. Instead I get 18,446,744,073,709,600,000.

Thank you very much!
Last edited by commonman123 on Thu Nov 17, 2011 4:43 pm, edited 1 time in total.
Open Office 3.3.0 on Windows XP
commonman123
 
Posts: 2
Joined: Thu Nov 17, 2011 3:25 pm

Re: How to change the zeros at the end of long numbers

Postby MrProgrammer » Thu Nov 17, 2011 4:24 pm

Hi, and welcome to the forum.

Calc, and many other spreadsheets, perform calculations to about 15 significant digits of precision. So all Calc knows about 2^64 is that it is approximately 1.84467440737096 times 10^19. Calc does not know that it is exactly 18,446,744,073,709,551,616. If you ask Calc to display digits beyond …709 it will provide a 6 and then zeros because no more significant digits are available. If you want to work with large integers, you will need to use something other than a spreadsheet. A web search should locate some suitable software for you.

If this answered your question 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.
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: 3945
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: How to change the zeros at the end of long numbers

Postby commonman123 » Thu Nov 17, 2011 4:42 pm

Ah, I see. Well, thank you very much for the help ^^
Open Office 3.3.0 on Windows XP
commonman123
 
Posts: 2
Joined: Thu Nov 17, 2011 3:25 pm

Re: How to change the zeros at the end of long numbers

Postby jrkrideau » Fri Nov 18, 2011 7:19 pm

commonman123 wrote:Ah, I see. Well, thank you very much for the help ^^

Perhaps Maple or Mathmatica can help but I believe that they are rather expensive. There probably is an OpenSource equivalent but I don't know a name.

 Edit: Apparently there are relatively inexpensive Maple and Mathematica licences for students. 
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests