Forum Discussion
Sorting and Formatting Dates Formula
Hi! I am pulling data from one sheet (Current Employees) in a workbook to a new sheet (Anniversaries). I want to sort a column of dates by month and day. The original data is in a m/d/yyyy format (ex...
That works, but when I inserted a column, it changed the formatting for another column. It is a date in the original sheet (and it's being used for calculations in another column), but now, on the sheets where I am extracting the array, it shows the serial numbers. Is there a way to lock the formatting for that column so the dates show as dates on the other sheets?
