View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I set the default date

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"