I want to type "121505" in a cell and it display 12-15-05. What formatting do I use? Thanks
C Cyrus Feb 28, 2006 #1 I want to type "121505" in a cell and it display 12-15-05. What formatting do I use? Thanks
C CLR Feb 28, 2006 #2 Right-click > FormatCells > NumberTab > Custom > ##-##-## in the small window Vaya con Dios, Chuck, CABGx3
Right-click > FormatCells > NumberTab > Custom > ##-##-## in the small window Vaya con Dios, Chuck, CABGx3
G Gord Dibben Feb 28, 2006 #3 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
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
