| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format the month of date
I want to format any user enterable date which is "mm/dd/yy" into month as
"mm" but as text. e.g. for 6/6/6 the variable should return "June" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to format the month of date
Jeni, with a helper column, assuming dates in Column A, in B1, insert
=Text(A1, "mmmm") and copy down. If you want to remove the helper column, copy Column B and Paste Special/Values over column A. HTH Greg Jeni wrote: I want to format any user enterable date which is "mm/dd/yy" into month as "mm" but as text. e.g. for 6/6/6 the variable should return "June" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to format the month of date
Jeni, or just use a custom format of mmmm.
Greg Jeni wrote: I want to format any user enterable date which is "mm/dd/yy" into month as "mm" but as text. e.g. for 6/6/6 the variable should return "June" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to format the month of date
dim myDate as date
dim myMonthStr as string 'something that gets mydate from the user. mymonthstr = format(mydate,"mmmm") If I understand correctly. Jeni wrote: I want to format any user enterable date which is "mm/dd/yy" into month as "mm" but as text. e.g. for 6/6/6 the variable should return "June" -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to format the month of date
Thanks Greg it worked
"GregR" wrote: Jeni, with a helper column, assuming dates in Column A, in B1, insert =Text(A1, "mmmm") and copy down. If you want to remove the helper column, copy Column B and Paste Special/Values over column A. HTH Greg Jeni wrote: I want to format any user enterable date which is "mm/dd/yy" into month as "mm" but as text. e.g. for 6/6/6 the variable should return "June" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| How to display month only for date format? | Excel Worksheet Functions | |||
| How to display month only for date format? | Excel Discussion (Misc queries) | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| code pasting a date changes date format in current month only | Excel Programming | |||
Linear Mode
