copy/paste 16 digit number

[Pariah81]

When pasting numbers Excel converts any digits after 15 digits to "0"

so 1234567812345678 becomes 1234567812345670

I need to cut and paste from an email.

Is there a way to paste so the 16th digit shows correctly (without going manual)

Perhaps with a auto prefix of comma?

Thanks

 

[sandy666]

probably because you copied value from email with any format and pasting to the sheet it will change format of the cell
with txt file format from email is removed and stay with simple text format

 

[Pariah81]

Yes but you got it to work by copy pasting from my opening post. I couldn't.

 

[sandy666]

I copied number from your first post which is reformatted to text so I copied text and paste text to text formatted cell
you copied number from email which is formatted as ... eg. html, rich text or whatever

 

[Pariah81]

I also tried copying and pasting from my first post.

 

[sandy666]

but you got solution with txt file which is work for you

have a nice day