Thread: [Solved] Date conversions
View Single Post
 
Old 03-29-2018, 01:01 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote