Dear Ravinder,
Thank you very much.
It works well.
Best regards
Sanusi
On 13 June 2014 17:30, Ravinder wrote:
> Try below
> =TEXT(DATE(RIGHT(B14,4),MID(B14,4,2),LEFT(B14,2)),"DD-MMM-YY")
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
Try below
=TEXT(DATE(RIGHT(B14,4),MID(B14,4,2),LEFT(B14,2)),"DD-MMM-YY")
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mohd Sanusi Mohd Noor
Sent: Friday, June 13, 2014 2:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-
