Jan 27 2022 05:44 AM
Jan 27 2022 05:51 AM
If you want to keep the number as it is, use the custom number format
Keep in mind that you'll have to divide by 100 if you want to perform calculations with the number.
Alternatively, with 1,184893 in A2, enter the formula =A2/100 in B2 and format B2 as a percentage.
You can then use B2 in calculations directly.