Dates
Posted by Jeanne on August 29, 2001 6:09 AM
I am having a problem formatting dates. When you format a cell for ex., phone number, SSS#: you format the cell then just type in the numbers without having to type in the dashes. I have had no luck doing this with the Date Format function. How do you enter the dates to make them automatically format??
Posted by Mark W. on August 29, 2001 7:04 AM
Dates must be entered with hyphens or slashes (e.g.,
12-31-01, 12/31/01). For more info on dates see
the Excel Help topic, "Tips on entering dates and
times".
