| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert month number to string
I have a master sheet in which date is stored in columns by month. Row 1 has
the year and row 2 has the month number (1 to 12). There are presentation sheets that reference subsets of the master data and on those sheets I would like to display a 3 char string for the month e.g. 'JAN' for month 1. Any suggestions, please? -- Graham |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List File Properties - Author | Excel Worksheet Functions | |||
| Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
| How to COnvert text string to number | Excel Discussion (Misc queries) | |||
| How to convert string to a date | Excel Worksheet Functions | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Threaded Mode
