I an using a csv format which requires the date field to be MM/DD/YYYY, but must include all the characters, not just to be formatted to look like that. Currently the only way I can figure to do it is by changing the field to a text field and re-keying the data. This won't work for me for a larger spreadsheet with many dates, so I was hoping someone knew how to take a regular date and make it MM/DD/YYYY without being complicated. Help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Date Format MM/DD/YYYY
- Thread starter lmcghee
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 19,961
- Office Version
-
- 365
- Platform
-
- Windows
Insert a column, and put the following formula:
=TEXT(A1,"mm/dd/yyyy")
Copy down.
Copy and paste special values over the originals.
Delete the column you just put the formula in.
=TEXT(A1,"mm/dd/yyyy")
Copy down.
Copy and paste special values over the originals.
Delete the column you just put the formula in.
Upvote
0
