View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carla Carla is offline
external usenet poster
 
Posts: 78
Default first letter of weekday

I am making a calendar, and need a cell that shows the first letter of the
weekday. i.e. M, T, W, T, F, S, S

I have formatted with "d", but of course that gives me a number. I have
tried =left, but that gave me the first number of the 5 digit serial number.
I have tried "ddd" and then =left, and it keeps converting to a number. Any
help would be appreciated.

Thank you,
Carla