I have a list of Fruits and the month that is sold.
Now someone has entered the month in TEXT format 1,2,3,..., 11,12.
I want it to be Jan, Feb, Mar,...,Nov, Dec.
Writing IF-ELSE is a tedious one. I was trying it in that way.
Can you please highlight some easy way.
Go to Solution.
First you can create custom month and give code 1 to 12
and then in the module you can use format list(Custom Month) to line item Month in Alphabet and then you need to use formula finditem
Thank You Panji for taking your precious time to help.
Please tell me, using this I get the output in List format.
But I want it in Text format.
Can you kindly show me the process.
Create a new line item in text format, Use NAME function to convert list format to text format.
Month Alpha Text = NAME(Month Alpha)
Yes, like @VIGNESH.M say
You just need create a new line item and write formula NAME(line item Month alpha)