Ask Your Question

Revision history [back]

It is a question of formatting.

I entered "0.04/12" (no quotes) (notice also no '=') in a cell of a brand-new spreadsheet & got the same ('04/12/2015') (if I enter "=0.04/12" (no quotes) I get '0.003333...').

Next, I formatted as '%':-
(menu):Format|Number Format|Percent (Ctrl+Shift+5)

...now I enter "=4/12" (no quotes) & it shows '33.33%'.

If this helps then please tick the answer (✔).