copy/paste 16 digit number

Pariah81

New Member
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
 

MARK858

Well-known Member
Try formatting the cell as Text before doing the paste.

Edit: Too slow :(
 
Last edited:

sandy666

Well-known Member
I copied the number from your post and pasted into text formatted cell - it works
 

Pariah81

New Member
still not working. any idea where I'm going wrong?

>New workbook, Select all, format to Text, copy & paste.
 

Pariah81

New Member
As I paste into the cell converts back to 'General'

Any way to stop that?
 

sandy666

Well-known Member
or you can try from email to the text file then copy from text file to the text formatted sheet
 

Pariah81

New Member
Hey Thanks. That worked perfectly.

still not sure why it didn't work direct in excel and kept auto changing the format. I think its a glitch of some kind.
 

Some videos you may like

This Week's Hot Topics

Top