Change date format

Closed
stalin - Mar 16, 2010 at 01:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 16, 2010 at 01:28 AM
Hello,
I typed like this - 18/05/1985, Now I need to change like 18-May-1985. I changed Date format but it is not change and this kind of format. give me a idea,

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 16, 2010 at 01:28 AM
two possible reasons.

1. The date is a text and not a date. This could be coz the cell was formatted to be text before date was entered or there is a ' before date

2. your system is set to recognize mm/dd/yyyy and your data is in dd/mm/yyyy format
0