B
brhudgens
Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I am trying to format a date with month and day, such as 4/27. I can format the column of dates to show the date correctly. When I save the worksheet as a .csv file in order to use it for a data merge in another program, it seems that the date is saved as 27-Apr instead of 4/27. If I enter the date in my xls file using the text identifier, '4/27, I still get the same problem. How can I maintain the appearance of the date information when saving the xls file as csv?
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I am trying to format a date with month and day, such as 4/27. I can format the column of dates to show the date correctly. When I save the worksheet as a .csv file in order to use it for a data merge in another program, it seems that the date is saved as 27-Apr instead of 4/27. If I enter the date in my xls file using the text identifier, '4/27, I still get the same problem. How can I maintain the appearance of the date information when saving the xls file as csv?