How can i copy a 16 digit number to excel from another software(HT

R

Rob van Gelder

You'll need to treat the cell as text, instead of a number.

Prior to copying the number to Excel, prepare the cell by formatting it as Text.

The downside is, you wont be able to use it for maths without helper functions.

Cheers,
Rob
 
F

FSt1

hi.
i don't think you can. not a true number. the limit is 15 digits. excel
should show the 16 digits in the formula bar so after pasting on the sheet,
you could preceed the number with an apostrophe so that it would show 16
digits on the sheet but excel would consider it as text.

regards
FSt1
 
Top