Since Excel uses IEEE format for double-precision numbers, and that format is
limited to 15 digits of precision, what do the last 5 digits of your "numbers"
look like? If the cell is formatted as General, I expect they are all 0's.
For example, I have a very wide column and a cell format of general. I type
12345678901234567891
and what I see is
12345678901234500000
Yes, that's a 20-digit "number", but it isn't the number I typed.
On Mon, 21 Mar 2005 21:30:19 -0000, "Gordon"
wrote:
Bernard Liengme wrote:
|| The free add-in XNUMBERS will allow this.
|| Find it at http://digilander.libero.it/foxes/
|| best wishes
Rubbish! Just make sure the column width will take it, and the cell is
formatted for number. I've just done it in a new workbook in Excel 2003.