Is there a way (by formatting or functions) to type a date into a cell with
no slashes and then it will be formatted with slashes?

For example...If I want to type into a cell the date for Sept 10th 2006 and
i type 091006 is there a way for it to format in the cell with the slashes.
If I format the cell with a date format (and slashes) and I type into the
cell 091006, I get back 02/28/49. Is there a feature available to be able to
type the literal date into the cell without the slashes and receive that date
in the cell with slashes? I understand the 1900 date formatting but I wasn't
sure if there is a work around.

No built-in Excel feature.

See Chip Pearson's site for event code to make the change as you enter the
091006

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


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 11:45:03 -0700, SDoyle@CAInc
wrote:

Is there a way (by formatting or functions) to type a date into a cell with
no slashes and then it will be formatted with slashes?

For example...If I want to type into a cell the date for Sept 10th 2006 and
i type 091006 is there a way for it to format in the cell with the slashes.
If I format the cell with a date format (and slashes) and I type into the
cell 091006, I get back 02/28/49. Is there a feature available to be able to
type the literal date into the cell without the slashes and receive that date
in the cell with slashes? I understand the 1900 date formatting but I wasn't
sure if there is a work around.

Hi sdoyle,

Excel ignores the leading zero and reads 91006 as 28th Feb 2049.
I don't know if there is a VBA solution but in normal circumstances
you have to follow Excels format.
To shorten your input you can use 9/10/6 and format the result
as you wish. The same amount of keystrokes just hitting the slash
at the top of the number pad instead of the zero at the bottom.

HTH
Martin

Another option is this Add-in
http://www.rondebruin.nl/qde.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
No built-in Excel feature.

See Chip Pearson's site for event code to make the change as you enter the
091006

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


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 11:45:03 -0700, SDoyle@CAInc
wrote:

Is there a way (by formatting or functions) to type a date into a cell with
no slashes and then it will be formatted with slashes?

For example...If I want to type into a cell the date for Sept 10th 2006 and
i type 091006 is there a way for it to format in the cell with the slashes.
If I format the cell with a date format (and slashes) and I type into the
cell 091006, I get back 02/28/49. Is there a feature available to be able to
type the literal date into the cell without the slashes and receive that date
in the cell with slashes? I understand the 1900 date formatting but I wasn't
sure if there is a work around.