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