i cant get the exact answer e.g answer is 13.49% i got 13.00%

Z

zai

My answer doesn't show my decimal point answer e.g the exact answer is
13.49%, i got 13.00% why my anwer has been round up ....
 
N

Niek Otten

What formula? What input values? What format?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
P

Peter Jausovec

Hi Zai,

You should check the cell formatting (right click on the cell and select
Format Cells...), then in Category select Percentage and check the number of
decimal places.

Hope this helps.

Peter
 
J

JustinLabenne

How are you going about getting this answer? Is it the result of
formula?
Have you checked the cells formatting?
 
Top