Excel can only handle 15 digits. Precede the number with a single quote
(apostrophe).
--
Gary''s Student - gsnu200761


"alank" wrote:

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