| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
making numerical date return mmmm format
I have one cell formatted as a number and I am trying to get it to
format to a different cell as mmmm and I need it to update everytime I change the numerical cell. Example: A1 has 1 as number A10 is referring to A1 with custom format of mmmm which returns January. My problem is that when I change A1 to 2 A10 does not update to show February. Please help... am I doing something wrong? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a different date format | Excel Worksheet Functions | |||
| I want my combo box to return a date format instead of a number? | Excel Discussion (Misc queries) | |||
| Are you kidding me??? Are you telling me I can't sort format: dddd, mmmm dd, yyyy? | Excel Discussion (Misc queries) | |||
| using lookup to return more than one answer in date format | Excel Worksheet Functions | |||
| Return Numerical Label for LAST value Subtracted to reach Sum Target Value | Excel Worksheet Functions | |||
Threaded Mode
