problem with dates in csv file

  • Thread starter Thread starter saybut
  • Start date Start date
S

saybut

Hi,

I'm trying to save a .csv file at the moment, the person who I'
sending it to needs the dates in 1 column as dd-mmm-yy, eg 18-Sep-05
eg 09-Sep-05. When I save the file it always reverts the dates 09 o
below back to a single number, 9 etc.

I've tried copying the column into word, paste special as text
formatting the column in excel to text and pasting special back in a
text, it works ok but when I save and open the file it reverts back!

does anyone know how I could get around this?

Many thanks,

saybut
 
The key is re-open.

If you save as .csv and look at the .csv file in, say, Notepad, the leading
zero will be there. When you re-open the file in Excel, Excel tries to
"help" you by removing the leading zero. If you re-name the file from .csv
to .txt and then open it in Excel, Excel will start the import wizard, which
will give you control over the import process.
 
Back
Top