| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformat dates to yyyy/mm/dd
hi
formulas cannot return formats only values. right click the cell in question and apply a custom format.... in the type box of the custom catagory enter.... yyyy/mm/dd regards FSt1 "Katerinia" wrote: I have a worksheet with dates of mm/dd/yyyy I need to reformat them now to be yyyy/mm/dd Whats the formula for that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reformat dates | Excel Discussion (Misc queries) | |||
| Force excel to read dates as D/M/YYYY | Excel Worksheet Functions | |||
| In Excel, is there a way to enter dates in mm/yyyy format? | Excel Discussion (Misc queries) | |||
| How to convert the dates from the YY:DD forma to MM/dd/YYYY format | Excel Worksheet Functions | |||
| Excel 2003 Mis-Translates Imported DD/MM/YYYY Dates | Excel Discussion (Misc queries) | |||
Threaded Mode
