Home |
Search |
Today's Posts |
#10
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
excel stopped working | Excel Discussion (Misc queries) | |||
Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions | |||
Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions |