How to interchange the date format

Closed
Report
-
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
-
Hello,

I have my date format as 01.02.2015 but when we replace the . with / it shows as 01/02/2015 which is 02-Jan-2015. I want to show it as 01-Feb-2015. Please help me with this.


1 reply

Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
You will have to do the input in Month-Day-Year order.
But from there use a custom format for that cell or group of cells.
Use the format dd-mmm-yyyy