Subtracting two numbers - result has decimals

[successone]

I have the following two cells which I increased the decimal out several places to make sure it had only 2 places. When I look at the result, it is more than 2 places. there is no multiplication or division happening. I will copy and paste the two cells and then the result. Very strange. If anyone can help, it would be truly appreciated. Thanks! Scott

4053855.270000000000000000000000000 4053855.260000000000000000000000000000 0.010000000242144

 

[Marcelo Branco]

Hi Scott,

Take a look at
Floating-point arithmetic may give inaccurate results in Excel

You should use the ROUND function

M.

 

[sheetspread]

Is the cell formatted as text and/or custom formatted?

 

[successone]

Hi Scott,

Take a look at
Floating-point arithmetic may give inaccurate results in Excel

You should use the ROUND function

M.

M.

I am taking the numbers directly from export into a .csv. The link was incredibly technical, but I think I found some items that give some credence to the results. thanks for pointing me in that direction. Thanks for taking the time to reply today!

Scott

 

[successone]

Is the cell formatted as text and/or custom formatted?

Sheetspread - all cells involved are formatted as number

 

[Marcelo Branco]

M.

I am taking the numbers directly from export into a .csv. The link was incredibly technical, but I think I found some items that give some credence to the results. thanks for pointing me in that direction. Thanks for taking the time to reply today!

Scott

You are welcome.

Glad that the link is helpful in some way.

M.