Month problem

[Shales]

Hi,

I am struggling to remember how to convert a number in a column (1) to (Jan)

For example in Column A I have a list numbers ranging from 1 to 12 (Jan to Dec) In Column B I want a formula to convert them into "MMM".

Please remind me.

Thanks

Gavin

 

[Richard Schollar]

Lewiy

When you hit the Jeanie button and it takes you to the main Jeanie dialog, just hit the underscore button to the right of the "Analyse range (Forum)" text box, and then select the cells you want to return formulas for in the html.

 

[Lewiy]

Cheers Richard! That should make my posts a little more concise. This thing has a lot more flexibility than first expected!!