LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do i ensure people use the right date format in excel?

I am trying to set up a column where people enter the date that they are
attending an event. In order to keep things neat and ensure that we can sort
the column, we need all the dates to be entered in the same format. How on
earth can we do this with Excel?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can adjust Format Rows Autofit to ensure WYSIWYG when printing GraySmithy Excel Worksheet Functions 2 September 3rd 05 03:37 PM
Can one adjust Format Row Autofit to ensure WYSIWYG when printing GraySmithy Excel Discussion (Misc queries) 2 September 2nd 05 02:26 PM
How can I ensure #records in a selected set always shows in Excel RangerBill Excel Discussion (Misc queries) 1 August 8th 05 08:14 PM
Excel 2000 date format cannot be set to Australian date format Brian Jones Excel Discussion (Misc queries) 1 March 30th 05 06:03 AM
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. KymY Excel Discussion (Misc queries) 3 February 11th 05 02:28 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"