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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
File in use by another application or user 2
How to change font & size of (all) citation numbers? 7
Stop excel rounding my 16/17 digit numbers 2
Paragraph numbering in Word 1
I need to add spaces to the beginning of my texts which are numbers 1
Shortcuts in OneDrive 0
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Top