vb/excel formatting question
Posted on 2003-12-01
I have a 16 digit number in a tab delimited text file. When I import it into excel, it does one of the following:
1) converts the last digit into a zero if i do the following formatting:
xlsheet.columns(2).NumberFormat = "#"
2) converts the number into scientific notation if i do the following formatting:
xlsheet.columns(2).NumberFormat = "@"
I thought the second should treat it as text!
Does anyone know what sort of formatting is needed in order to leave the number as is. I dont know if this makes a difference, but I am importing the tab limited file using the following code:
dim CSVBook as workbook
dim xlBook as workbook
Set CSVBook = Workbooks.Open(filename)
xlbook.saveas FileName:=newFileName, FileFormat:=xlExcel9795
Any help would be appreciated.