Formatting day of the week

J

Jordon

I know that formatting a date with ddd shows the first three letters
of the day, but is there a way to show only the first letter of the
day (Mon = M, Tue = T)?

TIA,
 
P

Paul Hyett

In microsoft.public.excel on Wed, 26 Dec 2007, Jordon
That saved me a bunch of work. Thanks Dave!
Click to expand...

Though with only one letter, how could you tell the difference between
Tuesday/Thursday & Saturday/Sunday?
 
C

carlo

If you don't have enough space and you do the days continually it's no
problem to distinguish between Tuesday (M T W) and Thursday (W T F).

Saw that already plenty of times.

cheers Carlo
 
Top