hello...I need help with the formatting of a column in an excel sheet. this sheet is used by multiple users. In one of the columns, dates are input into the cells to indicate delivery dates.These could be exact dates or could be week ending or week commencing.eg 21/05/08 or w/e 21/05/08 or w/c 21/05/08.everybody uses different ways of showing this eg w.e. 21-05-08 w.e 21-05-08 and so on.This column looks a right mess due to all the different ways people choose to display the dates.
Is there a way to just display a uniform type of formating for whatever way they choose display the delivery date however they type it in
Another possibility is to have W/E etc in a separate column from the date. You could set up a list of allowable entries in the W/E column and use Data Validation so that the user can select an allowable entry from a drop-down list - see click here