0.9%
Chat with our AI personalities
I would use the Format options, not a function.
format
Second Number / First Number provides the second number as a percentage of the first. If there is an increase, simply subtract 1 from the result, and multiply by 100. If you do not multiply by 100, you are left with the result in decimal format.
The number as presented is already in decimal format.
Your question is a little vague, but it sounds like a display issue. Specifically, it sounds like you have your number display set to show zero digits past the decimal point. Simply select the cell you're interested in reformatting, click on Format/Cells/Number/Percentage and make sure you have it set to display at least one (if not more) decimal digits.