How do I set the default date
Kruppy wrote:
I realize I can format it. There are lots of date formats available in excel.
Excel chooses the DEFAULT date when I enter what it sees as a date. How do I
change that default.
"Mike H" wrote:
Hi,
What do you want to see when yo do this? 10/11
if so
Format|Cell|Number tab
select Custom
and enter the custom format of
mm/dd
Mike
"Kruppy" wrote:
The help file says to set the date in Control Panel. My regional setting in
control panel shows the default date as 10/11/08 but when I enter in "10/11"
it is changed to "11-Oct"
You could set the sheet up the way you want it and then save it as a
template.
gls858
|