Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing a certain date format in an Excel column
Hello-
How can I restrict user data entry in a column to a certain date format? MM/DD/YYYY any help much appreciated! thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing a certain date format in an Excel column
Hi Angela,
You could set the cell to use Data Validation (see Data|Validation on the menu). With this, you can even force the input date to fall within a specified date range - which you could base on the current date if you want to. For example: .. click Data|Validation|Settings .. Allow = 'Date' .. Data = 'between' .. Start Date = '=DATE(YEAR(TODAY()),1,1)' .. End date = '=TODAY()' .. uncheck 'Ignore blank' This would force the user to input a date between 1 January this year and today. Providing your regional settings are in month-day-year form, the user will have to input the date in MM/DD/YYYY form. Cheers -- macropod [MVP - Microsoft Word] "angela" <angela @discussions.microsoft.com wrote in message ... | Hello- | How can I restrict user data entry in a column to a certain date format? | MM/DD/YYYY | | any help much appreciated! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forcing Save as in the format of Excel 2007 | Excel Discussion (Misc queries) | |||
forcing date to excel | Excel Worksheet Functions | |||
Format an Excel Column in the window's short date format. | Excel Programming | |||
Forcing english date format | Excel Worksheet Functions | |||
Forcing a specific date format | New Users to Excel |