Formating cells to only accept ShortDate format

  • Thread starter Thread starter JShrimps, Jr.
  • Start date Start date
J

JShrimps, Jr.

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.
 
Why not just format the date as mm/dd/yy and let the user type the date in any
format they like?
 
Why would you want to do this?
Excel does not store the date in that format, but as a
decimal number and cell formatted as Date.
Just pre-set the cell format as "##/##/##" and it won't
matter what they type, it will display the short format.

Kevin Beckham
 
After formating a group of cells as "##/##/##",
and typing in "December 12, 2003", results in
"December 12, 2003" in the cell.
I have to limit the data entry to the "##/##/##" format only.
No text strings allowed.
 
Try Data|Validation and tell it to only accept dates.

but I typed in "december 12, 2003" in a cell and I got the date back. But I
formatted it as mm/dd/yy (under custom).
 
Back
Top