I have data that has been dumped to excel from SAP. Some of the cells are showing a custom date format of mm/dd/yyyy (example: 01/01/2002). The data really should really be text and be 01-01-02. It isn't a date at all. I can make it look like 01-01-02 as a date but when I try to change it to text it makes it a 5 digit number. Anyone know the formula to convert to the format I want?
Thanks!
Thanks!