Formatting decimal places but value in input box does NOT change

[thewiseguy]

Hello all. Here is my problem:

Input box at the top of my screen: 370.442748091603
I need the value to be: 370.44
when I reduce the decimal places, the value in the cell changes but the value in the text box up at the top does NOT

Is there anyway to make the value in the text box change?

Any help is appreciated!


*Edit - another question would be, why is my data 13 places long? What is making it do this? This output is a result of formulas from multiple worksheets but I don't see the decimal places out that far anywhere else.

 

[Asbestos_Jen]

Excel doesn't take significant figures into account. You need to round the data manually if you want rounded numbers, not just change the number of decimals displayed. Hope this helps:

Book1
	B	C
3	Input box at the top of my screen:	370.443
4	I need the value to be:	370.44
5	Mround	370.44
6	Round	370.44
Sheet1

Cell Formulas
Range	Formula
C5	C5	=MROUND(C3,0.01)
C6	C6	=ROUND(C3,2)

 

[MARK858]

This output is a result of formulas from multiple worksheets

If your result as you state above is the result of a formula then you need to wrap the actual formula in one of the round functions @Asbestos_Jen has shown you.
I am assuming here that by "Input box at the top of my screen" you mean the formula bar, which will always show the actual value (although if you have a formula not converted to values it should be showing the formula) and not what the cell is formatted to show.

 

[thewiseguy]

Excel doesn't take significant figures into account. You need to round the data manually if you want rounded numbers, not just change the number of decimals displayed. Hope this helps:

Book1
	B	C
3	Input box at the top of my screen:	370.443
4	I need the value to be:	370.44
5	Mround	370.44
6	Round	370.44
Sheet1

Cell Formulas
Range	Formula
C5	C5	=MROUND(C3,0.01)
C6	C6	=ROUND(C3,2)

This worked perfectly. Thank you Jen

 

[Asbestos_Jen]

Glad to have helped. Thanks for the feedback.