Page 1 of 1

Can not change 100% to 100

PostPosted: Tue Oct 09, 2018 8:34 pm
by Maria2018
Hi all, new here so please be gentle :)
I was inputting a value of 100% into a couple of different columns (database) but then I found out that the percent sign % shouldn't be there. So I tried to delete it. But when I delete just the % sign or delete the entire value of 100% and then enter the value of 100, for some reason I get 10000.00%.
I've tried different cells and it's always the same! If the value was 50% and I try to change to 50 it makes it 5000.00%
So not only it won't let me delete the % sign and puts it right back but it also adds a couple of 00 to every value I enter
I would appreciate some help!

Re: Can not change 100% to 100

PostPosted: Tue Oct 09, 2018 10:23 pm
by UnklDonald418
Percent is simply a way of displaying a fraction as a whole number.
1 displays as 100%
.5 displays as 50%
.252 displays as 25.2%
The HSQLDB database engine stores the fraction in the table, it knows nothing about percent.
The Base front end multiplies the fraction stored in the database table by 100, adds the % character and displays that result. That is why you are seeing those large numbers.
If you want to enter something like 50% and have it saved as .50, you need to create a Base form instead of entering data directly into the table.
Actually, you should use use Base forms for entering and editing data in most situations.

Re: Can not change 100% to 100

PostPosted: Tue Oct 09, 2018 10:33 pm
by Maria2018
thanks for replying but this doesn't solve my problem. It's a custom form given to me by a company and I have entered about 5 days worth of data. Then they told me that I shouldn't use the % symbol. But when I go to delete it, it puts it right back plus changes the number by adding 00.00 to it.
There must be a way to go into each cell and change from 100% to 100 or from 50% to 50
It's so basic. There must be some kind of formatting going on that doesn't allow me to make this simple change?

Re: Can not change 100% to 100

PostPosted: Wed Oct 10, 2018 3:55 pm
by Maria2018
well, easily fixed it in excel by changing formatting. Couldn't figure out how to do it in OO

Re: Can not change 100% to 100

PostPosted: Wed Oct 10, 2018 4:13 pm
by UnklDonald418
I did some testing, the problem is with
a custom form given to me by a company

It appears the form has a Formatted Field control that has its Formatting set to Percent. To change that behavior would require editing the form which would be best done by the form designer.
We might be able guide you through the form editing process, but if the spreadsheet does what you need that's the way to go.

Re: Can not change 100% to 100

PostPosted: Wed Oct 10, 2018 4:23 pm
by Maria2018
thank you for taking the time to help me!