| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display only first letter of Weekday in number format | Excel Discussion (Misc queries) | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Threaded Mode
