Date Format Change dd-mm-yyyy to dd-mon-yyyy

**NAGRAJ** · 08-09-2013, 04:27 AM

Dear all,

anybody help that i want date format change in Excell

Actual Format : 09-08-2013 ( dd - mm - yyyy )
Required Format : 09-Aug-2013 ( dd - Mon - yyyy )

Please give your valuable suggestions to change the formats for one to other.

Thanks& regards,
Nagaraju

**Crispy85** · 08-09-2013, 09:41 AM

Hi Nagaraju,

Right click on the range, or cell, select Format Cells, in the tab Number select Custom field, and there you can enter a type.
Just make it this: dd-mmm-yy

Regards,

**AlKey** · 08-09-2013, 10:00 AM

You can also do it by formula:

=TEXT(B3,"dd-mmm-yyyy")

**NAGRAJ** · 08-09-2013, 10:20 AM

Dear All,
Thank you Very Much.

NAGARAJ

Date Format Change dd-mm-yyyy to dd-mon-yyyy

LinkBack

Thread Tools

Rate This Thread

Display

Date Format Change dd-mm-yyyy to dd-mon-yyyy

Re: Date Format Change dd-mm-yyyy to dd-mon-yyyy

Re: Date Format Change dd-mm-yyyy to dd-mon-yyyy

Re: Date Format Change dd-mm-yyyy to dd-mon-yyyy

Thread Information

Users Browsing this Thread

Similar Threads

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

[SOLVED] Change date format from YYYY-MM-DD hh:mm:ss to YYYY-MM-DD

[SOLVED] how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel

change date format from dd/mm/yyyy to mm/yyyy

Bookmarks

Bookmarks

Posting Permissions