| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display 5 into May in mmm format?
Does anyone know how to display 5 into May in mmm format for excel?
If I input the number 5 in cell A1, then I would like to see May in cell B1. Does anyone have any suggestion? Thank you for any suggestion Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display 5 into May in mmm format?
=DATE(YEAR(NOW()),A1,1)
Format as "mmm" -- HTH, Laura Cook Neenah, WI "Eric" wrote in message ... Does anyone know how to display 5 into May in mmm format for excel? If I input the number 5 in cell A1, then I would like to see May in cell B1. Does anyone have any suggestion? Thank you for any suggestion Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display 5 into May in mmm format?
If you want this to be a TEXT value:
=IF(A1="","",TEXT(DATE(2006,1,A1*29),"mmm")) Biff "Eric" wrote in message ... Does anyone know how to display 5 into May in mmm format for excel? If I input the number 5 in cell A1, then I would like to see May in cell B1. Does anyone have any suggestion? Thank you for any suggestion Eric |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display 5 into May in mmm format?
Thany everyone for suggestion
Eric |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display 5 into May in mmm format?
You're welcome!
Biff "Eric" wrote in message ... Thany everyone for suggestion Eric |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display 5 into May in mmm format?
Hi Biff
Interestingly this also works with just =(A1="","",TEXT(A1*29,"mmm")) -- Regards Roger Govier "T. Valko" wrote in message ... If you want this to be a TEXT value: =IF(A1="","",TEXT(DATE(2006,1,A1*29),"mmm")) Biff "Eric" wrote in message ... Does anyone know how to display 5 into May in mmm format for excel? If I input the number 5 in cell A1, then I would like to see May in cell B1. Does anyone have any suggestion? Thank you for any suggestion Eric |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display 5 into May in mmm format?
I had a "duh moment" after I had posted.
Instead of: =IF(A1="","",TEXT(DATE(2006,1,A1*29),"mmm")) It could be simply: =IF(A1="","",TEXT(DATE(2006,A1,1),"mmm")) Interestingly this also works with just =(A1="","",TEXT(A1*29,"mmm")) Yes, even better. Nice and compact! If A1 = 1 for month January 1*29 = 29 = serial date for Jan 29 1900 Biff "Roger Govier" wrote in message ... Hi Biff Interestingly this also works with just =(A1="","",TEXT(A1*29,"mmm")) -- Regards Roger Govier "T. Valko" wrote in message ... If you want this to be a TEXT value: =IF(A1="","",TEXT(DATE(2006,1,A1*29),"mmm")) Biff "Eric" wrote in message ... Does anyone know how to display 5 into May in mmm format for excel? If I input the number 5 in cell A1, then I would like to see May in cell B1. Does anyone have any suggestion? Thank you for any suggestion Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy with format | New Users to Excel | |||
| How do I display time in a negative format? | Excel Worksheet Functions | |||
| display no seconds in time format [h] | Excel Discussion (Misc queries) | |||
| How do I calculate and display ratio ( format 3.5:2) | Excel Worksheet Functions | |||
| Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) | |||
Linear Mode
