|
|
#2
03-29-2018, 01:01 PM
|
||||
|
||||
Format the cells as Number > Custom > mm-yy
or, to ensure it stays in your format, in another column enter formula =TEXT(A1,"mm-yy") Then you can copy and paste special > Values over original and then delete formulas. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unwanted conversions with PowerPoint presentations | xlcfdp | PowerPoint | 0 | 10-03-2017 02:04 PM |
| Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
 How can a document have the same date modified/create date, yes have have actual file content?
|
legaleagle | Word | 15 | 01-07-2015 06:58 PM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
|
Meaning of current date vs status date when saving baselines
|
ketanco | Project | 1 | 02-08-2012 02:20 PM |
Windows 10 
Office 2013
Threaded Mode