[Solved]My Spreadsheet Keeps rounding off my account number

Discuss the spreadsheet application

[Solved]My Spreadsheet Keeps rounding off my account number

Postby Mitupogo » Fri May 24, 2019 5:49 pm

I've looked for answers and tried some that are similar - changing autoformat options, changing cell options....

NO LUCK.

I'm doing a new spreadsheet. Budget. I put in the first columns fine. Name, Dollar Amount, Date, etc. I get to the Account number column, and I type in the account number. It ends in "68". The sheet keeps changing it to 70, AND in the cell contents window at the top, it's putting in some kind of calculation with + sign, etc. I tried new sheet, etc. No luck. Help!
Last edited by thomasjk on Sat May 25, 2019 9:20 pm, edited 1 time in total.
Reason: Mark thread [Solved] and add green checkmark
OpenOffice 4.1.6 on Windows 10
Mitupogo
 
Posts: 2
Joined: Fri May 24, 2019 5:42 pm

Re: My Spreadsheet Keeps rounding off my account numbers!

Postby FJCC » Fri May 24, 2019 6:37 pm

You probably have to format the cells as text. Use the menu Format -> Cells and on the Numbers tab set the Category to Text.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7230
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: My Spreadsheet Keeps rounding off my account numbers!

Postby Mitupogo » Fri May 24, 2019 6:45 pm

Thanks so much. Doing the text format worked. Still WEIRD. Thanks!
OpenOffice 4.1.6 on Windows 10
Mitupogo
 
Posts: 2
Joined: Fri May 24, 2019 5:42 pm

Re: My Spreadsheet Keeps rounding off my account numbers!

Postby RusselB » Fri May 24, 2019 7:10 pm

Not so much weird, but a lack of understanding how Calc works with numbers.
Numbers up to and including 15 digits in length are handled properly...16 digits or more are affected by rounding to bring the number compliant with the 15 significant digit count.
Since the account numbers aren't needed for any calculations, they can easily be marked as text, as FJCC suggested.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5299
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: My Spreadsheet Keeps rounding off my account numbers!

Postby jrkrideau » Sat May 25, 2019 12:44 pm

RusselB's explaination applies to any program BTY. Fifteen digits is the limit of accuracy due to the fact that computers work in binary not decimal arithmetic.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3690
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: robleyd and 35 guests