Long numbers turning into scientific notation

Discuss the spreadsheet application

Long numbers turning into scientific notation

Postby DEANDOWNSOUTH » Fri Jan 18, 2008 10:49 pm

Hey folks. I'm trying to put in a transaction number in a cell but rather than taking the number as I put it in, it converts it. Here's the example:
242244372545784423200015 becomes 2.42E+023

the only way to get the number to stay as I want it is to break it up by spaces, I chose groups of three. I've tried formating the cells as text, numbers, general all have the same problem.

thanks!
DEANDOWNSOUTH
 
Posts: 1
Joined: Fri Jan 18, 2008 10:34 pm

Re: Long numbers turning into scientific notation

Postby Hagar Delest » Fri Jan 18, 2008 11:15 pm

Change your cell format to Number and add a decimal place (Format cells, Numbers tab).

But you'll see that 242244372545784423200015 has been changed to 242244372545784000000000,0! This is because OOo is limited to 15 decimal digits IIRC. It may be the same in any spreadsheet.
LibreOffice 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29084
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Long numbers turning into scientific notation

Postby Dave » Sat Jan 19, 2008 12:00 am

Being a transaction number, it will not be used to do calculations, presumably. So, make it text by preceding with an apostrophe, as in '242244372545784423200015

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: Long numbers turning into scientific notation

Postby Hagar Delest » Sat Jan 19, 2008 12:04 am

Dave wrote:Being a transaction number, it will not be used to do calculations, presumably.

Of course :roll: I missed that.

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.
LibreOffice 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29084
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 31 guests