On Wed, 30 Mar 2005 01:55:02 -0800, CiaraF
wrote:
I'm trying to display 16 digit numbers in excel but it keeps converting the
last digit to a zero. Is there a way to format the cells so the 16 digits are
displayed and can be used in a vlookup formula ?
Excel (and most spreadsheet) specifications are in accord with an IEEE standard
which has a 15 digit precision.
The only way to do what you want is to enter the value as TEXT. Either precede
your entry with an apostrophe (which will not be displayed; OR format the cell
as TEXT prior to making your entry.
VLOOKUP will work with TEXT entries.
--ron
|