Replace "/" in excel with "-" (change date format)

Hello,

I am trying to do a find a replace to change the format of dates in an excel spreadsheet. They are currently listed as 9/9/99 and I need them to be 9-9-99. I tried doing a find and replace but it seems that you can not replace anything with a "-". Is there any work around here?

Thank you so much,
Sean
grindmygearsAsked:
Who is Participating?
 
Sushil SonawaneConnect With a Mentor Commented:
right click on cell or column select format option on number tab select the custom make a format as you want.
0
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

Change to a custom format

like M-D-YYYY
or
D-M-YYYY

see example

http://excel-example.com/other-tutorial/custom-format-of-date-and-time-in-ms-excel

Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.