| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| How do I copy the last digit of a number from a cell | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Hybrid Mode
