R
rexmann
Hi All
I am trying to get just the year and month of a date to display and I am using
=year(A1)
=month(A1)
the year is fine but the month appears as a number 1-12. I have tried
changing the field to custom month but this just give the wrong answer. I can
use a v-lookup to convert which is no problem but a bit messy (I remember in
2003 it worked fine)
Any suggestions greatly appreciated
cheers Rexmann
I am trying to get just the year and month of a date to display and I am using
=year(A1)
=month(A1)
the year is fine but the month appears as a number 1-12. I have tried
changing the field to custom month but this just give the wrong answer. I can
use a v-lookup to convert which is no problem but a bit messy (I remember in
2003 it worked fine)
Any suggestions greatly appreciated
cheers Rexmann