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

  • Thread starter Thread starter Sourav
  • Start date Start date
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
 
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
 
Back
Top