FindingInformation
New Member
- Joined
- Jan 5, 2019
- Messages
- 3
I have to convert a text file into excel 2010 for which I have written a marco
This file has column that contains long numbers and alpha numeric data.
My issue:
I have converted cell into Text(script below), alpha numeric number is fine however, when there are numbers more than 20 digits, excel is converting them with as 'E+15' or 'E+16' and changing last numbers to 00000.
Example: Excel Cell B should have -> but has this
8723894787834575644666 -> 8.72389478783457E+21(Incorrect)
AB8927349827 -> AB8927349827 (Correct)
This macro script converts column B to text however, it doesn't convert long numbers correctly. Any suggestions?
VB script I am using :
objExcel.columns(2).NumberFormat = "@"
Thanks in advance.
This file has column that contains long numbers and alpha numeric data.
My issue:
I have converted cell into Text(script below), alpha numeric number is fine however, when there are numbers more than 20 digits, excel is converting them with as 'E+15' or 'E+16' and changing last numbers to 00000.
Example: Excel Cell B should have -> but has this
8723894787834575644666 -> 8.72389478783457E+21(Incorrect)
AB8927349827 -> AB8927349827 (Correct)
This macro script converts column B to text however, it doesn't convert long numbers correctly. Any suggestions?
VB script I am using :
objExcel.columns(2).NumberFormat = "@"
Thanks in advance.