Convert Date in Text to month and Year
in [Functions]
|
Prev: Data Validation drop-down width, with named range source (XL03 and
Next: Trying to convert mm/yy in text to Dec-07, it adds day & curre
From: Excellency on 23 Mar 2010 21:31 I am trying to convert text to month and year. In the cell it displays as 07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it adds current year and displays something like 02/15/2010. Any idea what i am doing wrong.. thanks
From: H�ctor Miguel on 23 Mar 2010 21:48 hi, ! try to follow (and provide feed-back in) your previous post (???) regards, hector.
From: Fred Smith on 23 Mar 2010 22:41 See your previous posts. Regards, Fred "Excellency" <Excellency(a)discussions.microsoft.com> wrote in message news:BBD51CC5-AC5A-4513-851B-B329054527E3(a)microsoft.com... >I am trying to convert text to month and year. In the cell it displays as > 07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it > adds current year and displays something like 02/15/2010. Any idea what i > am > doing wrong.. > > thanks
From: T. Valko on 23 Mar 2010 22:42
I may be over-complicating this, but that's what I do!!! How to solve this depends on the possible year span of the dates. If a date is 07/22 is that the date Jul 2022 or Jul 1922 Are the dates *always* in the year 2000 or greater? -- Biff Microsoft Excel MVP "Excellency" <Excellency(a)discussions.microsoft.com> wrote in message news:BBD51CC5-AC5A-4513-851B-B329054527E3(a)microsoft.com... >I am trying to convert text to month and year. In the cell it displays as > 07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it > adds current year and displays something like 02/15/2010. Any idea what i > am > doing wrong.. > > thanks |