Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Conversion
If I receive this number, 268435457801266887, in e-mail and paste it into
Excel, I get this: 2.68435E+17. If I then go into Format Cells and change it from General to Number (no decimals), I get this: 268435457801266000 Is there a way I can actually get those last three zeroes to be the actual numbers (887 in this case)? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Conversion
Do not paste into a cell.
Copy from the email Click in the formula bar directly Enter an apostrophe (sinlge quote) Then CNTRL-v This will allow you to capture ALL the digits -- Gary''s Student - gsnu200828 "Toria" wrote: If I receive this number, 268435457801266887, in e-mail and paste it into Excel, I get this: 2.68435E+17. If I then go into Format Cells and change it from General to Number (no decimals), I get this: 268435457801266000 Is there a way I can actually get those last three zeroes to be the actual numbers (887 in this case)? Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Conversion
Excel only maintains up to 15 digits of precision in a number. You
will have to consider that as text if you want to retain all the digits. Pre-format the cell as text before pasting. Hope this helps. Pete On Jan 21, 12:25*am, Toria wrote: If I receive this number, 268435457801266887, in e-mail and paste it into Excel, I get this: 2.68435E+17. *If I then go into Format Cells and change it from General to Number (no decimals), I get this: 268435457801266000 Is there a way I can actually get those last three zeroes to be the actual numbers (887 in this case)? Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Conversion
Perfect! Thank you!
"Gary''s Student" wrote: Do not paste into a cell. Copy from the email Click in the formula bar directly Enter an apostrophe (sinlge quote) Then CNTRL-v This will allow you to capture ALL the digits -- Gary''s Student - gsnu200828 "Toria" wrote: If I receive this number, 268435457801266887, in e-mail and paste it into Excel, I get this: 2.68435E+17. If I then go into Format Cells and change it from General to Number (no decimals), I get this: 268435457801266000 Is there a way I can actually get those last three zeroes to be the actual numbers (887 in this case)? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number conversion | Excel Discussion (Misc queries) | |||
Number Conversion | Excel Worksheet Functions | |||
Number Conversion | Excel Discussion (Misc queries) | |||
Number Conversion | Excel Discussion (Misc queries) | |||
Number conversion | Excel Discussion (Misc queries) |