I am make a table with one column being percentage.
I first made the field type numeric and then format example set it to percent -13%
then tried integer with the same format example
Both when I enter my value of 85% change to zero when I go to the next line.
it did however take 8500%..
any ideas?
thank you
Enter percentage in Base
Enter percentage in Base
Open Office 4.3.1, Windows 11
-
- Posts: 318
- Joined: Sun Sep 06, 2020 8:27 am
Re: Enter percentage in Base
Usually a "formatting as %" multiplies the value by 100 and appends the character '%'. So your field must accept digits after the . or the value will be rounded/truncated.
If you wish to store % as integer, you can do this, but have to create your own formatted field with '%' like you would do for cm, °F etc.
J.
If you wish to store % as integer, you can do this, but have to create your own formatted field with '%' like you would do for cm, °F etc.
J.
OpenOffice 3.1 on Windows Vista