| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cells shows current month only in number format
Hello. How can make a cell show the current monht? So for if its October it
shows the number 10 in a cell? I've tried data, today, etc... the closest I've gotten is to show an O for October, but I need the number. Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cells shows current month only in number format
=CHOOSE(MONTH(TODAY()),1,2,3,4,5,6,7,8,9,10,11,12)
-- hope to help, cm "Benny" wrote: Hello. How can make a cell show the current monht? So for if its October it shows the number 10 in a cell? I've tried data, today, etc... the closest I've gotten is to show an O for October, but I need the number. Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cells shows current month only in number format
actually, month(today()) works alone.
-- hope to help, cm "Benny" wrote: Hello. How can make a cell show the current monht? So for if its October it shows the number 10 in a cell? I've tried data, today, etc... the closest I've gotten is to show an O for October, but I need the number. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of even weeks in the current month. | Excel Worksheet Functions | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
| how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
Hybrid Mode
