Format for date in cell

  • Thread starter Thread starter Priscilla
  • Start date Start date
P

Priscilla

Is it possible to format a cell to give the date in
mm/dd/yyyy format without having to type the backslash in
the initial entry?
 
Priscilla said:
Is it possible to format a cell to give the date in
mm/dd/yyyy format without having to type the backslash in
the initial entry?
Click to expand...

Not simply by formatting. Except in the case of formatting a cell as text,
formatting a cell has no effect on how data entry is interpreted. Formatting
affects how an entry is displayed, not how data is entered.

To do what you ask requires VBA. Look here for details:
http://www.cpearson.com/excel/DateTimeEntry.htm
 
Back
Top