Hi,
Whenever I create a new Calc sheet and apply the Percent format, the number is 10000,00%
What I actually need is 100%, so each time I have to manually change the formatting:
Can I change the default format permanently?
What did you enter into the cell? what was calculated for it?
You can define and apply a cell style with percent format string “0%” (no decimals).
You can not change the fact that 100=10000%.
There are two issues anyway:
- You cant change the default percent format for automatic application.
- If a cell is already formatted as a percentage, an input number like “55” is interpreted as “55%”. That’s illogical, but people seem to like it this way.