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

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 ....

What formula? What input values? What format?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"zai" wrote in message
...
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 ....

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
--
http://blog.jausovec.net


"zai" je napisal:

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 ....

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