Excel Rounding Issue

[love and hate excel]

I would like to round these three numbers to 4 decimal places using formula.

Initial Data​	Required Result​
37464.0120999999​	37464.0121​
37464.0121999999​	37464.0122​
37464.0122999999​	37464.0123​

I then want to copy and paste values on the formula. (It’s for a large volume of data so I want the end user to avoid any calculations)

I would like the numbers stored as numbers, not text. (I want to avoid using “Text to columns” function to fix it)

Is it possible???

 

[Dave Patton]

Are the results not correct?

 

[Fluff]

Not if you copy/paste them.

 

[awoohaw]

when I did a copy and paste of the cells with the ROUND function it kept the 1,2,3 in the 4th decimal position.
Where are you pasting the data?

Book1
	A	B	C	D
1	Initial Data		Required Result	Column B Values Pasted
2	37464.0120999999	37464.0121	37464.0121	37464.0121
3	37464.0121999999	37464.0122	37464.0122	37464.0122
4	37464.0122999999	37464.0123	37464.0123	37464.0123
Sheet4

Cell Formulas
Range	Formula
B2:B4	B2	=ROUND(A2,4)

 

[Fluff]

Try selecting D3 & look in the formula bar, or expand the number of decimals being shown.

 

[awoohaw]

Try selecting D3 & look in the formula bar, or expand the number of decimals being shown.

isn't that goofy.

Book1
	A	B	C	D
3	37464.0121999999	37464.0122	37464.0122	37464.0121999999
Sheet4

Cell Formulas
Range	Formula
B3	B3	=ROUND(A3,4)