[Solved] change numbers from 2 decimal points to show more

Discuss the word processor

[Solved] change numbers from 2 decimal points to show more

Postby sjohnston » Sun Sep 13, 2020 9:18 am

Would appreciate help in how to change the number of decimal points in numbers I need to show please.

I have a table in Writer in which I need to express percentages to more then 2 decimal points but Writer changes it when I enter a number greater then that.

For example I need to enter 0.00863256% Writer changes this to 0.01%.

The other thing I need to show is billion, million, thousand but write removes the commas making the number more difficult to read.

For example I need to show 7,811,473,000 Writer changes it to 7811473000.

Many thanks for your help.

Sally j
Last edited by robleyd on Sun Sep 13, 2020 11:31 am, edited 1 time in total.
Reason: Tagged [Solved]
sjohnston
 
Posts: 2
Joined: Sun Jun 17, 2018 2:54 am

Re: change numbers from only 2 decimal points to show more

Postby Zizi64 » Sun Sep 13, 2020 10:16 am

Tip1:

Switch off the automatis number recognition. Then the entered strings will not be recognized and reformat as numbers. The entered characters will not be changed in the text.

Tools - Options - Open/LibreOffice Writer - Table - Input in Table - Number recognition
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9586
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: change numbers from only 2 decimal points to show more

Postby robleyd » Sun Sep 13, 2020 10:25 am

If you have no need for number recognition in tables (you don't want to use calculations in the tables for example) you can globally turn off number recognition in Writer via Tools | Options | OpenOffice Writer | Table - under Input in tables uncheck Number recognition. This will disable number recognition for all future documents until you change the setting again.

Alternatively you can, on a per cell or per table basis, set the cell content to text by selecting the cells, or complete table, right click and use the Number Format option to either set the cells/table to text, or if you need calculations, to the appropriate number format.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3508
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: change numbers from only 2 decimal points to show more

Postby sjohnston » Sun Sep 13, 2020 11:08 am

Thank you Zizi64 & robleyd so much.

My life can go on :D

Sally j
Apache Open Office 4.1.5 on Windows 7
sjohnston
 
Posts: 2
Joined: Sun Jun 17, 2018 2:54 am

Re: [Solved] change numbers from 2 decimal points to show mo

Postby Villeroy » Sun Sep 13, 2020 12:16 pm

Number recognition is a good thing even if you don't calculate the numbers. Format the cells as you need them and you can simplify your data entry.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28644
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Writer

Who is online

Users browsing this forum: No registered users and 21 guests