Thread: Date format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default Date format

Type the following in to the custom format:

mmm-yy

"Pierre" wrote:

How would we get 2008-01 to read as "Jan-08"?, etc for months and
years.

I'd use a helper column if necessary. Custom format is better though.

TIA.

Pierre