| View previous topic :: View next topic |
| Author |
Message |
qaz1qaz1qa
Power User
Joined: 21 Jan 2012
Posts: 68
|
 Posted: Fri Feb 03, 2012 10:44 pm Post subject: [SOLVED]Turning Month Names into Numeric equivelant |
 |
|
I have a drop down list of the Months by name. Is there a way to turn these into the numeric equivalent?
I suppose I could use a Vlookup or some kind of chart comparison. But for some reason in the back of my head I think this exists already as a function.
Last edited by qaz1qaz1qa on Sun Feb 12, 2012 9:12 pm; edited 1 time in total |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Sat Feb 04, 2012 12:52 am Post subject: |
|
|
If the name of the month is in D1
=MONTH( VALUE( "1. " & D1 ) )
to get the numeric equivalent
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
qaz1qaz1qa
Power User
Joined: 21 Jan 2012
Posts: 68
|
| Posted: Fri Feb 10, 2012 5:45 am Post subject: |
|
|
I got an answer on the other board. Close to the one you gave.
However I guess it depends on where I live as I needed to keep a different format
=MONTH( VALUE( "1. " & D1 ) ) had to be changed to
=MONTH( VALUE( "01-"&D1&"-01" ) )
See
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=47516
_________________
OO 3.3 XP |
|
| Back to top |
|
|
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Fri Feb 10, 2012 8:27 am Post subject: |
|
|
Thanks for cross-posting in other forums - and not mentioning it 
This is rude.
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
qaz1qaz1qa
Power User
Joined: 21 Jan 2012
Posts: 68
|
| Posted: Fri Feb 10, 2012 8:44 am Post subject: |
|
|
_________________
OO 3.3 XP |
|
| Back to top |
|
|
|
