problem with dates in csv file
 

Hi,

I'm trying to save a .csv file at the moment, the person who I'm
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 or
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 as
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.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=484241

problem with dates in csv file
 

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.
--
Gary's Student


"saybut" wrote:


Hi,

I'm trying to save a .csv file at the moment, the person who I'm
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 or
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 as
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.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=484241

problem with dates in csv file
 

Ah... Thank you very much.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=484241