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]

change format of cell/column to Text then paste

 

[MARK858]

Try formatting the cell as Text before doing the paste.

Edit: Too slow

 

[Pariah81]

Tried that. Doesn't work when copy/pasting.

 

[sandy666]

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

 

[Pariah81]

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

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

 

[Pariah81]

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

Any way to stop that?

 

[sandy666]

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

it works also

try change one cell to text format and paste single number, eg: 1234567812345678

 

[sandy666]

or you can try from email to the text file then copy from text file to the text formatted sheet

 

[Pariah81]

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.