S
StargateFan
Sorry about this but a recent question re custom date format was a
special case type of scenario and I'm finding that I still don't know
how to change to my preferred date format for most spreadsheets.
The new sheet I'm trying to fix might show how to do this once and for
all. In today's sheet I have 2 cells, B2 is formatted as "ddd" and C2
as "mmm.dd.yyyy". C2 is a date entered by user where B2 is dependent
on C2 via the formula "=C3". I was hoping to finally learn how to get
XL to change the "ddd" format of"
Sun, Mon, Tue, Wed, Thu, Fri Sat
to:
Sn, Mn, Tu, Wd, Th, Fr, Sa.
Thank you. D
special case type of scenario and I'm finding that I still don't know
how to change to my preferred date format for most spreadsheets.
The new sheet I'm trying to fix might show how to do this once and for
all. In today's sheet I have 2 cells, B2 is formatted as "ddd" and C2
as "mmm.dd.yyyy". C2 is a date entered by user where B2 is dependent
on C2 via the formula "=C3". I was hoping to finally learn how to get
XL to change the "ddd" format of"
Sun, Mon, Tue, Wed, Thu, Fri Sat
to:
Sn, Mn, Tu, Wd, Th, Fr, Sa.
Thank you. D