Nick;
Thanks.
As I noted in my response to Dave, this was the 1st time I'd seen this and was wondering
If I'd "slipped a cog" somewhere.

Also, I believe the max # is 1E14 (15 digit number) which doesn't concern me because my
Key will never exceed 14 digits, but thanks for the reminder.

--
Regards;
Rob
------------------------------------------------------------------------
"Nick Hebb" <n.hebb@comcast.net> wrote in message
news:1117405304.892092.37500@f14g2000cwb.googlegroups.com...
> Rob, are you doing Autofit and Number cell formatting, or just Autofit?
> I tried this out and saw the issue with numbers greater than 11
> digits. Like you said, changing the width didn't help. But changing
> the format to Number (with 0 decimal places) did.
>
> Playing around a bit, I also found that numbers > 1E16 have truncated
> precision, so you may want to watch out for that if you're
> concatenating very large numbers
>