Quick and easy one for you! I have the months of the year as list box properties. My months are showing as Jan-14, Feb-14 etc, how do I change this to show Jan, Feb etc without manually changing all these in my excel spreadsheet.
May be like this.
In the script
I recommend: =Month(Date#(YourField , 'MMM-YY'))
This gives you output which is responsive to all date functions.
Where do I use this formula? The script or excel?
In the Script level...
Retrieving data ...