Thread
: [Solved]
Date conversions
View Single Post
03-29-2018, 01:01 PM
NBVC
Windows 10
Office 2013
The Formula Guy
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
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.
NBVC
View Public Profile
Find all posts by NBVC