How to interchange the date format

Closed
Ashish - Feb 19, 2015 at 12:25 PM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 20, 2015 at 10:05 AM
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

cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 7
Feb 20, 2015 at 10:05 AM
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
0