When I enter a large number into and Excel, the last digit of the number
defaults to zero.

I have tried all the different cell formats available and none of them allow
a different ending digit - other than zero 0