Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Number
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Number
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...p?ref=jandlmcc "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Number
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 - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Number
"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? This problem arises with all versions of Excel, not just Excel 2007. Excel recognizes only the first 15 significant digits of numbers, and it ignores (and strips) leading zeros of integral numbers (e.g. 000123). If you format the cell as Text __before__ entering numeric strings, or if you prefix the numeric strings with an apostrophe (single quote), you can enter numeric strings of 16 or more digits and numeric strings that with leading zeros that you want to preserve. Also, if you are importing from a text file, the Import Wizard allows you to specify that a column is text. But if you format the cell as Text __after__ entering a numeric string of 16 or more digits or a numeric string with leading zeros, you are SOL. Excel has already modified value. The only remedy is to re-enter the numeric string as described above. ----- original message ----- "RedCattledogs" wrote in message ... 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...p?ref=jandlmcc "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |