Thread: data format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote