thank you mr sixthsense may i modif the formula to be:
=DATE(YEAR(
DATEVALUE("1Jan"&RIGHT(B2,2))),MID(TEXT(B2,"000000"),3,2),LEFT(TEXT(B2,"000000"),2))
On Fri, May 13, 2011 at 6:03 PM, Sixthsense <sixthsense...@gmail.com> wrote:
> Hi Stdev,
>
>
> Your Solution will fail when the person intended to mention the year 1998
> in this manner 10498.
>
>
> ---
> *Sixthsense
> **:) Man of Extreme & Innovative Thoughts :)*
>
>
> On Fri, May 13, 2011 at 4:13 PM, STDEV(i) <setiyowati.d...@gmail.com>wrote:
>
>> *
>> =DATE(2000+RIGHT(B2,2),MID(TEXT(B2,"000000"),3,2),LEFT(TEXT(B2,"000000"),2))
>> *
>>
>> see the attachment
>>
>>
>>
>> On Thu, May 12, 2011 at 7:14 PM, Prabhu <prabhugate...@gmail.com> wrote:
>>
>>> Hi friends,
>>>
>>> Plz help to change date format when downloaded report from 1st of every
>>> month to 9th of the month will be like DMMYY .
>>>
>>> I have no issue in changing the format using text to column from 10th
>>> date because it will be in DDMMYY.
>>>
>>> I have attached the sample sheet for your reference.Plz help to know the
>>> date format as DDMMYY for entire month.(i am requesting macros to do the
>>> same)
>>>
>>> Regards,
>>>
>>> Pr
>>>
>>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
ctv__bsninvreport(V2).xls
Description: MS-Excel spreadsheet
