LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Opening an Excel file Sheldon Zaklow Excel Discussion (Misc queries) 0 March 3rd 05 10:29 PM
excel stopped working Steve Excel Discussion (Misc queries) 0 January 13th 05 04:07 AM
Sum function not working correctly in Excel (Skips Cell) Tony Excel Worksheet Functions 5 November 29th 04 11:52 PM
Replace function not working properly in Excel 2000 SP3 rgbytg Excel Worksheet Functions 5 November 11th 04 03:44 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"