Excel date format to be change

Closed
charles - May 8, 2010 at 10:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 8, 2010 at 11:25 AM
WOULD LIKE TO CHANGE THE DATE 07.05.2010 TO 07-05-2010 FORMAT
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 8, 2010 at 11:25 AM
Have you tried to format the date to say
dd-mm-yyyyy?

If you excel is not recognizing it as a date then first you have to convert it to date. To do that, see this
https://ccm.net/forum/affich-340448-date-formate#1
0