Hi Gordon,

Yes, that's why I cancelled the post. It does 15. I wonder why the OP wants
20 digits?

Well, some people actually need high precision calculations. But it may also
be a code number of some sort, in which case formatting as text will do the
job nicely.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com