Thread: How can i copy a 16 digit number to excel from another software(HT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob van Gelder Rob van Gelder is offline
external usenet poster
  
Posts: 37
Default 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)?
Reply With QuoteReply With Quote