Excel is automatically converting my text to a date(csv file)

[avishain]

Hello there,

im using excel 2007 and ive got the following problem:

column T (formated as general but i can format it as text if have to) consist of street numbers ,for instance :

15/7

when i import the excel file to csv file (by using VBA) ,excel shows this number as date ( july-15).

how can i fix that?

thanks

 

[Andrew Poulsom]

Are you saving as CSV? Does it appear as a date when opened in Notepad?

 

[avishain]

when i open it in notepad i see:

15/07 (instead of july-15 as i see in the csv file itself)

it happens also when i enter 15-7 (instead of 15/7)

the code for saving as csv is :

ThisWorkbook.SaveAs "c:\" & Format(Now, "ddmmyyyyhhmm") & ".csv", xlCSV, local:=True
ThisWorkbook.Close False
End Sub

 

[Hermanito]

If you open the CSV-file in Excel, its auto-convert routines already kick-in. Try to open it in Notepad or Wordpad... what does it show there?

I think you will have to format the cells first to Text format, then enter the data, then save as CSV... not tested that though.