Question

What actually changes the value excel stores to a user determined number of decimal places?

Answer 1

The ROUND function can be used to do this. The function, in its final argument, has a section that allows for the exact number of digits that the returned value should be truncated at, which will set the exact number of decimal digits stored in that cell.