If you go out past 15 digits in Excel it lists the sixteenth digit as 0 when
formatted as Number, with no decimal places or thousand separators.
You've been misled by Microsoft's help system into posting this Excel
question in a Microsoft Access newsgroup.
However, Access (and C, and FORTRAN, and Visual Basic, and the vast
majority of programs) are limited by the size of a Double Precision
floating point number. Such a number uses 64 bits to store a 48 bit
binary fraction and a 16 bit exponent (IIRC). This means you can store
approximately 14 or 15 decimals of precision... but no more.
If you're using this field for calculations, you'll need to use a
Decimal datatype and ask in one of the microsoft.public.excel
newsgroups if Excel supports such. If you're just using it for an
identifier put a ' before it and use it as a text field instead of any
sort of number.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
