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 ....
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
zai Wrote:
> 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 ....
--
JustinLabenne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks