Month - Date

[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

[Michael Solomon \(MS-MVP Windows Shell/User\)]

lynne wrote:
> 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
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
--
Michael Solomon MS-MVP
Windows Shell/User
Backup is a PC User's Best Friend
DTS-L.Org: http://www.dts-l.org/