ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can i copy a 16 digit number to excel from another software(HT (https://www.excelbanter.com/excel-worksheet-functions/250410-how-can-i-copy-16-digit-number-excel-another-software-ht.html)

Sourav

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)?

Rob van Gelder

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)?


FSt1

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 08:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com