date entry without typing dashes
 

I want to type "121505" in a cell and it display 12-15-05. What formatting do
I use?

Thanks

date entry without typing dashes
 

Right-click FormatCells NumberTab Custom ##-##-## in the small window

Vaya con Dios,
Chuck, CABGx3



"Cyrus" wrote:

I want to type "121505" in a cell and it display 12-15-05. What formatting do
I use?

Thanks

date entry without typing dashes
 

Cyrus

You could format as ##-##-## but would not be a date, just a formatted number.

For quick-entry dates and times see Chip Pearson's site for VBA methods.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Tue, 28 Feb 2006 11:36:25 -0800, "Cyrus"
wrote:

I want to type "121505" in a cell and it display 12-15-05. What formatting do
I use?

Thanks