ExcelBanter - data format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - data format (https://www.excelbanter.com/excel-discussion-misc-queries/216674-data-format.html)

ec17

data format

How do I keep a date in the format Sep 08 (for september 2008)? Excel keeps
changing it to 01/09/2008.

Gord Dibben

data format

Format to mmm yy

Or enter as text 'Sep 08

Note the apostrophe.

Gord Dibben MS Excel MVP

On Thu, 15 Jan 2009 16:37:00 -0800, ec17
wrote:

How do I keep a date in the format Sep 08 (for september 2008)? Excel keeps
changing it to 01/09/2008.

All times are GMT +1. The time now is 08:15 PM.