Formatting cell data in Calc: percentage, fraction and scientific notation
Posted by Greten on 13 Apr 2013 under Tools
This is a very old post. Updating it is difficult so it has been divided into three posts when it was updated to include Google Sheets and Microsoft Excel.
- Formatting percentage in spreadsheet applications
- Formatting fractions in spreadsheet applications
- Formatting scientific notations in spreadsheet applications
Last updated on 12 Oct 2020.
Learn from others
Trying to set up LibreOffice database, but the two decimal points always revert to zero. Why? For example if I write in 120.87 the systems writes in 120.00 And if I try to change the .00 to say, 50, it still reverts to .00 What am I doing wrong?
Share your thoughts
* Required. Your email will never be displayed in public.
I can type a fraction with a horizontal fraction bar and it appears OK ini Libreoffice. However, after I save, close the document and reload it, the fraction has moved upward on the screen and seems to appear as an exponent. I can double-click the fraction and it moves back down where it is supposed to be. However, If I save again, close and reload it is back up. Any suggestions.