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?

Change date format in excel
How to change date format in excel - Guide
Marksheet format in excel - Guide
How to change author in excel - Guide
Format factory - Download - Other
Change computer name cmd - Guide

1 response

Answer 1 / 1

sha
Oct 4, 2011 at 06:07 PM

TEXT(A1,"yyyy-mm")

A1=your date

Similar discussions

Date formatting in dd/mm/yyyy

Similar discussions

Subscribe To Our Newsletter!