Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save as csv cell format
I have WORKSHEET(1) with Column "C" formatted as dd/mm/yyyy
__with other values in other columns I copy and paste_special 'values' then I 'saveas' the file in *CSV format and when I open the CSV file the date format has changed to 'general' which is to be expected in CSV, but the value has also changed to m/dd/yyyy I need the format in the CSV file to be dd/mmm/yyyy thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save in a .prn format | Excel Discussion (Misc queries) | |||
How do I save a custom cell format that I created? | Excel Worksheet Functions | |||
How can I format an Excel cell with a "save" or other command? | Excel Programming | |||
Custom Cell Format Will Not Save Correctly | Excel Worksheet Functions | |||
save button in excel to save one of the worksheets with a cell value as its name | Excel Programming |