combining two cells into one gives different numbers

[asdnator]

If i use function =A1&B1 then sometimes it gives little different values although the data is same. How can i avoid this?

Capture2.PNG

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Where is the formula and why are you using =A1&B1 and not =A1+B1

Almost certainly you may think the data is the same but at the arithmetical precision level it won't be.