Previous Topic Next Topic

Change date format in excel

Closed
fmp - Oct 4, 2011 at 05:28 PM
 sha - Oct 4, 2011 at 06:07 PM
Hello,




My spreadsheet has date in cells as: 7/1/2003 but displays as Jul-03. Need to have date in cells as YYYY-MM. Anyone know how to convert, please?
Related:

1 response

Answer 1 / 1
sha
Oct 4, 2011 at 06:07 PM
TEXT(A1,"yyyy-mm")

A1=your date