Subtracting two numbers - result has decimals

successone

New Member
Joined
Jul 7, 2003
Messages
30
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

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,317
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.
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top