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
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