Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
spkersh
 
Posts: n/a
Default cell format in Excel 2002 SP3 will not accept long numbers

I try to input a number 17 digits long. The whole number fits in the cell
just fine, but it cuts off the last 2 digits of the number and changes the
digits to "00." It doesn't matter what font size I use, how wide I make the
cell, or what format number type I use. I tried using custom, general,
number, etc.. all do the same thing, changes the last 2 digits to "00."

How do I fix it? Why will the cell accept unlimited number length, but only
accept numbers up to 15 digits? Why is everything past the 15th digit
automatically changed to "0"?
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default cell format in Excel 2002 SP3 will not accept long numbers

XL's precision is limited to 15 digits. If you need to do math on more
digits than that, you'll need a different application.

If you simply want to display the 17 digit numbers, preformat the
cell(s) as Text, or prefix the entries with an apostrophe (').


In article ,
"spkersh" wrote:

I try to input a number 17 digits long. The whole number fits in the cell
just fine, but it cuts off the last 2 digits of the number and changes the
digits to "00." It doesn't matter what font size I use, how wide I make the
cell, or what format number type I use. I tried using custom, general,
number, etc.. all do the same thing, changes the last 2 digits to "00."

How do I fix it? Why will the cell accept unlimited number length, but only
accept numbers up to 15 digits? Why is everything past the 15th digit
automatically changed to "0"?

Reply
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
How do i get excel to format a cell for a negative result. Cisco Excel Discussion (Misc queries) 4 July 21st 05 08:40 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
How do I format a cell so that only specific numbers can be enter. Jim Excel Discussion (Misc queries) 1 February 1st 05 05:51 PM
Excel 2002: Format Cell Height/Width buddyfl Excel Discussion (Misc queries) 1 January 31st 05 07:01 PM


All times are GMT +1. The time now is 05:13 PM.

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

About Us

"It's about Microsoft Excel"