View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toria Toria is offline
external usenet poster
 
Posts: 38
Default 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.