Posted 01 March 2011 - 06:30 PM
Hi! I am having problems with saving a excel document as a .csv file. I open an excel file and right click on a cell and select format cells and then I select custom and type in mm/dd/yyyy for the date format I need and select okay, so when I type in a date like 05/05/2005 it will stay that way in excel. After this I click save and save file type to .csv, but before saving a message pops up saying "may contain features that are not compatible with CSV" and it will not let me save in .csv format. The thing is that a certain company needs the .csv format and when I send it they need the dates i enter to be in 00/00/0000 cell format. Does anyone know of a way to save a .csv file with the date being formatted that way?