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.
Friday, 9 August 2019
microsoft excel - Changing Cell Date Formats to Text Format and Retain mm/dd/yy
Subscribe to:
Post Comments (Atom)
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...
-
I'm working on some .bat stuff created in a legacy application, which uses many environment variables. I need to know exactly what is e...
-
Is it possible to use the tablet style on-screen keyboard on a Windows 8 laptop PC? I've found the 'Ease of Access' version whic...
-
On my desktop there are a sea of icons and I realy like ability to hide them. I can do that if do right click on desktop and find arrange ic...
No comments:
Post a Comment