Custom date format shows "051117.Thu" for today. Way to have "051117.Th", instead?
I don't think you can do it with a format. You can use a formula:
=TEXT(A1,"yymmdd.")&LEFT(TEXT(A1,"ddd"),2)
--
Kind regards,
Niek Otten
"StargateFan" wrote in message
...
With these standard abbreviations holding true for the entire week:
Mon = s/b Mn
Tue = s/b Tu
Wed = s/b Wd
Thu = s/b Th
Fri = s/b Fr
Sat = s/b Sa
Sun = s/b Sn
?
Hope it's possible. I have code that does something similar elsewhere
in XL2K, but nothing I've tried in converting it to this particular
spreadsheet's use, works. Thanks so much. :oD
|