View Single Post
  #10   Report Post  
Myrna Larson
 
Posts: n/a
Default

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.