--Dave--
Banned
Registered: 17th Feb 04
Location: Essssseeeeex Drives: Black Supra TT
User status: Offline
|
I have a column of dates in the normal format i.e 21/09/2005
In the column next to it I want to be able to display the month. So for example:
Column A | Column B
21/09/2005 September
I don't want to have to type this in for each one, there are about 6000 records. Anyone know a formula I can use?
Cheers
Gianluigi
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
Put this in column B
=TEXT(A1,"mmmm")
|
--Dave--
Banned
Registered: 17th Feb 04
Location: Essssseeeeex Drives: Black Supra TT
User status: Offline
|
James, you are a star
cheers mate
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
|
gianluigi
Member
Registered: 9th Mar 05
Location: Ipswich, Suffolk
User status: Offline
|
quote:
Originally posted by --Dave--
Gianluigi
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
 Didnt even notice that
|
gianluigi
Member
Registered: 9th Mar 05
Location: Ipswich, Suffolk
User status: Offline
|
i was trying to work out what he needed to to to solve his problem when i saw that
|
--Dave--
Banned
Registered: 17th Feb 04
Location: Essssseeeeex Drives: Black Supra TT
User status: Offline
|
I was relating back to that other thread, can't remember what it was about, but everyone was signing off as other members
Tom
|
gianluigi
Member
Registered: 9th Mar 05
Location: Ipswich, Suffolk
User status: Offline
|
oh right
--Dave--
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
I remember.
Ian
|
--Dave--
Banned
Registered: 17th Feb 04
Location: Essssseeeeex Drives: Black Supra TT
User status: Offline
|
oh dear, what have we started
Corsasplash
|
gianluigi
Member
Registered: 9th Mar 05
Location: Ipswich, Suffolk
User status: Offline
|
not much by the looks of things
Sam
|
--Dave--
Banned
Registered: 17th Feb 04
Location: Essssseeeeex Drives: Black Supra TT
User status: Offline
|
I want you Sam
Dave17
|
Shelly
Premium Member
Registered: 15th Nov 00
Location: Lancashire Drives: Astra H VXR
User status: Offline
|
I didn't know that one, thanks 
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
I'm an Excel guru  
|
Shelly
Premium Member
Registered: 15th Nov 00
Location: Lancashire Drives: Astra H VXR
User status: Offline
|
your handy to know.
i know how to do lookup tables
|
