Hi guys,
I used excel's OpenText method to load a very large text file. The source file is ok. In excel, the number 5402563000067965 is shown as 54+Exx, which is fine. When I format it as number & did a column autofit, the last number becomes 0, it now becomes 5402563000067960. Don't know whats wrong. Help??
Thanks.
I used excel's OpenText method to load a very large text file. The source file is ok. In excel, the number 5402563000067965 is shown as 54+Exx, which is fine. When I format it as number & did a column autofit, the last number becomes 0, it now becomes 5402563000067960. Don't know whats wrong. Help??
Thanks.