Either pre-format the cell as Text before you enter the number, or
include a preceeding apostrophe, eg:

'1234567890123456789

The apostrophe will not show in the cell.

Hope this helps.

Pete

On Aug 20, 12:35*am, RedCattledogs
wrote:
I have been using Excel since 1980s, and this 2007 version drives me crazy! *
I tried to forrmat the numbers in Text as you said, and 5.6789E +15 came out.
*How can I input larger than 15 digit numbers without Excel changing the
numbers?
I would appreciate help!



"John McCabe" wrote:
Had the same problem and they were able to help. * Mr. Excel only likes 15
numbers, so they had me format it as text and it works great now. *Sorry
excel does not like over 15 numbers.

--

http://www.bring2help2.com/opl/opera.../index.php?ref...
"Abdul" wrote in message
....
I am trying to format the number *12345612345123456 to display as
123456 12345 123456 by entering *a custom format code 000000 00000
000000. But the result display like 123456 12345 123400. Instead of
the last digits 56 it displays 00. ??

Thanks- Hide quoted text -

- Show quoted text -