software

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

ThanksRight-click gt; FormatCells gt; NumberTab gt; Custom gt; ##-##-## in the small window

Vaya con Dios,
Chuck, CABGx3
quot;Cyrusquot; wrote:

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

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.

www.cpearson.com/excel/DateTimeEntry.htmGord Dibben MS Excel MVP

On Tue, 28 Feb 2006 11:36:25 -0800, quot;Cyrusquot; gt;
wrote:

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