How do I show formatted numbers only in the formatted form in Excel cells?

So when I am using excel, sometimes a formula used will prompt an answer such as 67.9999999.

When I then paste this into another cell which I have formatted to 2 decimal places it shows 68, but in the top formula bar it will still show it as 67.99999.

How am I able to change this without manually going through each one and rewriting it in the 2 decimal place format, so both the cell and the formula bar now reflect the 2 decimal place number?



Category: microsoft excel Time: 2016-07-30 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 0.161 (s). 12 q(s)