I want to write an export file in a normal tab list to be imported and read by Excel. Unfortunately, one of the entries is a 12-digit number. When Excel reads it in, it automatically exponates it. Is there coding that can automatically tell Excel *not* to, so that the full 12-digit number is displayed?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel - importing 12-digit numbers
- Thread starter hademtoo
- Start date
- Status