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) |