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
-1

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses