Thread: Formating cells to only accept ShortDate format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default Formating cells to only accept ShortDate format
Why not just format the date as mm/dd/yy and let the user type the date in any
format they like?



"JShrimps, Jr." wrote:

Need to format some columns in ShortDate format only
so that the only values accepted are in "##/##/##" format.

If someone types in Dec. 10, 2003, for example, an error should
be genereated, and the user is reminded to enter
dates in "##/##/##" format.

--

Dave Peterson

Reply With QuoteReply With Quote