Change number from multiple decimals to 2
 

Can someone please help me figure out how to change a number that has
multiple declimal places (example 54.123456) to only 2 places (example
54.12). When I format the number to 2 decimals, it appears correct, however,
when I "click" on the number, it still shows the multiple decimals. I need
the number to only show 2 decimal places at all times. Any suggestions would
be greatly appreciated!
--
Diana

Change number from multiple decimals to 2
 

You can use Tools | Options | Calculation tab and then click on
Precision as displayed - when you click OK Excel will warn you that
you are about to change values, and that this is not reversible.

Hope this helps.

Pete

On Oct 22, 5:06*pm, DianaC wrote:
Can someone please help me figure out how to change a number that has
multiple declimal places (example 54.123456) to only 2 places (example
54.12). *When I format the number to 2 decimals, it appears correct, however,
when I "click" on the number, it still shows the multiple decimals. *I need
the number to only show 2 decimal places at all times. *Any suggestions would
be greatly appreciated!
--
Diana

Change number from multiple decimals to 2
 

=ROUND(A2,2)
--
David Biddulph

"DianaC" wrote in message
...
Can someone please help me figure out how to change a number that has
multiple declimal places (example 54.123456) to only 2 places (example
54.12). When I format the number to 2 decimals, it appears correct,
however,
when I "click" on the number, it still shows the multiple decimals. I
need
the number to only show 2 decimal places at all times. Any suggestions
would
be greatly appreciated!
--
Diana

Change number from multiple decimals to 2
 

Use the round function: =round(54.123456,2). The second input to the
function tells it to round to the second decimal place.

Don
"DianaC" wrote:

Can someone please help me figure out how to change a number that has
multiple declimal places (example 54.123456) to only 2 places (example
54.12). When I format the number to 2 decimals, it appears correct, however,
when I "click" on the number, it still shows the multiple decimals. I need
the number to only show 2 decimal places at all times. Any suggestions would
be greatly appreciated!
--
Diana