Importing csv to excel - text formating
Posted on 2016-11-24
Can you please help,
I'm trying to Copy data from a csv file File to my Excel Sheet. (Excel 2007)
Trying to Copy Columns A-AZ.
I formatted Column BD on my excel sheet, as text before Copying from the csv file.
Still, the numbers are showing as +11, +21,....
if I format Column BD as Custom 0, the numbers are showing with trailing zeroes.
9.61102E+21 6.48029E+11 7.75632E+11 7.756E+11 1.9747E+14
This is the code I'm using.
Dim fd As FileDialog
Dim strWorkbookName As String
Set fd = Application.FileDialog(msoFileDialogFilePicker)
.InitialFileName = "TEXT;C:\Users\Wass\Desktop\**.*"
.Filters.Add "", "*.csv", 1
If .Show = -1 Then
strWorkbookName = ActiveWorkbook.Name
Sheets("Orders").Range("BC1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Your help is greatly appreciated,