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.
|