Friday, 9 August 2019

microsoft excel - Changing Cell Date Formats to Text Format and Retain mm/dd/yy

I need to change cell dates with a general format (mm/dd/yy) to a text format for uploading to Peoplesoft. However I must retain the mm/dd/yy. When I change the cell from general format to text format it then changes the date to a serial number date such as 41982 etc. I don't want the serial number date. It must remain a text format cell with mm/dd/yy or mm/dd/yyyy etc.

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...