Re: [libreoffice-users] Re: Calc =MONTH problem

2013-08-20 Thread Brian Barker
At 01:10 20/08/2013 -0700, Graham Lovatt wrote: Eventually got what I wanted by using =TEXT(CG4,"MMM") Interestingly, this gives a different result from the formatting option. The results look the same, but mine was a formatted date (which will be right-aligned by default) and this is an act

[libreoffice-users] Re: Calc =MONTH problem

2013-08-20 Thread IGraham
Hello and thanks for looking at the problem So my understanding and logic was wrong - again I have learnt a smidgen more Eventually got what I wanted by using =TEXT(CG4,"MMM") I had thought of using an array but It seemed a big way of solving a small problem - plus I'd never used one before ?? Ma