Thread
:
Date format
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sam Wilson
external usenet poster
Posts: 523
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
Reply With Quote
Sam Wilson
View Public Profile
Find all posts by Sam Wilson