View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JShrimps, Jr. JShrimps, Jr. is offline
external usenet poster
 
Posts: 2
Default Formating cells to only accept ShortDate format

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.