![]() |
How can i copy a 16 digit number to excel from another software(HT
How can i copy a 16 digit number to excel from another software(HTML)?
|
How can i copy a 16 digit number to excel from another software(HT
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 Sourav wrote: How can i copy a 16 digit number to excel from another software(HTML)? |
How can i copy a 16 digit number to excel from another software(HT
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 "Sourav" wrote: How can i copy a 16 digit number to excel from another software(HTML)? |
All times are GMT +1. The time now is 04:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com