Excel Date Formatting

Giganews Newsgroups
Subject: Excel Date Formatting
Posted by:  Joe (jfrits…@bcbsm.com)
Date: Mon, 13 Oct 2003

I have a spreadsheet that I add additional lines to
occassionally.  Although I formatted the date fields to be
mm/dd/yy in advance, the date populates with mm/dd/yyyy.
It's frustrating to have to go back after entering each
date to reformat it.  Why can't I format the column in
advance and it retain the format?

Replies