excel help please

  broggs 19:21 14 May 2008

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

eg. W/E 21/05/08
W/C 21/05/08
Due 21/05/08


  VoG II 19:32 14 May 2008

I would use a Calendar Control click here

  broggs 19:46 14 May 2008

thanks vog but that looks a bit complicated for a learner like me.
The calender control looks ok but it is very important that the three variables are included with the date as required e.g

W/E 21/05/08
W/C 21/05/08
Due 21/05/08

  VoG II 19:53 14 May 2008

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

  broggs 20:06 14 May 2008

thanks vog looks like a possibility..will have a play around and report back.

  broggs 19:34 09 Sep 2008

once again ...thanks vog works perfect

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?