If a cell has been formatted as percent, if I enter 10.5 it should show as 10.55% (assuming 2 d.p.s). However all of a sudden it's started showing as 1055.00%. Is there any way to fix it?
2006-09-01 05:32:09 · 3 answers · asked by shahlordsaway 2 in Computers & Internet ➔ Software
easy!
you go in Tools, Options, in the Edit tab, and there is a box, "Enable automatic percent entry". If you tick it, then when you'll enter 10.5, it will be entered as 10.5%.
If it's not ticked (default) then you'd need to enter the actual number, i.e. 0.105, if you want the cell to display as 10.5%.
a
2006-09-01 05:42:16 · answer #1 · answered by AntoineBachmann 5 · 0⤊ 0⤋
Excel will convert the number to it's percentage. So if formatted as percent, enter .105 and it will display 10.5%
Another technique is to use tools->options->edit and select automatic percent entry.
2006-09-01 05:38:02 · answer #2 · answered by odu83 7 · 0⤊ 0⤋
I presume this is Excel.
Once you format the cell as percentage, it then expects a figure between 0 and 1. So 0.5 would be 50%
The way to fix it is to divide your figure by 100.
2006-09-01 05:38:47 · answer #3 · answered by Henry 5 · 0⤊ 0⤋