| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel 2002
I have inported some data into excel. I need to change the date column to
DD/MM/YYYY so that it can be imported into a different program that requires that format but I cannot find that format in the cell, format, date options. am I missing something? Please help |
|
#2
|
|||
|
|||
|
Right Click on the column of cells you need to format MM/DD/YYYY and choose
format cells then click on custom. Change the word General in the type box to MM/DD/YYYY "samsoncan" wrote: I have inported some data into excel. I need to change the date column to DD/MM/YYYY so that it can be imported into a different program that requires that format but I cannot find that format in the cell, format, date options. am I missing something? Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
| how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
| Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel 2002 not working | Setting up and Configuration of Excel | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Linear Mode
