Month - Date

  • Thread starter Thread starter lynne
  • Start date Start date
L

lynne

Is there a way to enter the month and date in excel
without having to press the hyphen (07-31) in between
numbers, specifically for another year other than 2003.
i.e. If I wanted 07/31/2002, is there a way just to
enter 073102, and it come up in the correct format?
07-31-2002

Thanks,
Lynn
 
lynne said:
Is there a way to enter the month and date in excel
without having to press the hyphen (07-31) in between
numbers, specifically for another year other than 2003.
i.e. If I wanted 07/31/2002, is there a way just to
enter 073102, and it come up in the correct format?
07-31-2002

Thanks,
Lynn
Click to expand...
Go to the following site, select Excel from the list on the left and try
posting your question there, please:
http://communities.microsoft.com/newsgroups/default.asp?icp=Prod_Office&sLCI
D=US&newsgroup=microsoft.public.excel.misc
 
Back
Top