Apologies, I'm thinking in terms of VBA here. Right, the reason this is coming up with two different answers is that when the text is applied to the cell as well as the number, the cell assumes the format is text and gives the number as accurate as possible to 15 significant figures, whereas if the formula is emtered without the text, the cell is formatted at a number without decimals (if you increase the number of decimals you will encounter the same issue as with the text).
To avoid this, you can either use the ROUND or TEXT functions:
The ROUND function instructs excel to round the number to a certain number of decimal places. The zero at the end of the ROUND function in the example below shows that the number will be rounded to zero decimal places.
The TEXT function turns the number into text and formats the string as you require. In the example below, the text is formated as "0", therefore an integer.
Apologies for the inconvenience, I didn't think to take into account the formatting of the result
Bookmarks