Custom Date Format

[SJT]

I would like to create a format in a cell that allows the number I enter to
be converted into a date in this format "MM/DD/YYYY". However, I would like
to be able to enter the numbers w/o having to use the "/" as a separator btw.
the month and day and the day and year. For example, if I enter the April
29, 2009 as "042909" in a cell, I would like the cell format to convert that
to "04/29/09" instead of "6/23/17" which is what it does now. Thank you in
advance for your assistance.

 

[מיכ×ל (מיקי) ×בידן]

May be you will have to adjust it because it works for "our" dd/mm/yy format.
Try using the following custom format:
00\/##\/##
You will not be able to run calculations on such cells.
If you need calaulation - try to use an helper-cell.
In A1 type the date without the "/" and in B1 type:
=TEXT(A1,"00\/00\/00")
*** The are not a Capital [ V ] those are \ / [separated for better
understanding ***
Micky

 

[SJT]

Thanks Micky.

May be you will have to adjust it because it works for "our" dd/mm/yy format.
Try using the following custom format:
00\/##\/##
You will not be able to run calculations on such cells.
If you need calaulation - try to use an helper-cell.
In A1 type the date without the "/" and in B1 type:
=TEXT(A1,"00\/00\/00")
*** The are not a Capital [ V ] those are \ / [separated for better
understanding ***
Micky

I would like to create a format in a cell that allows the number I enter to
be converted into a date in this format "MM/DD/YYYY". However, I would like
to be able to enter the numbers w/o having to use the "/" as a separator btw.
the month and day and the day and year. For example, if I enter the April
29, 2009 as "042909" in a cell, I would like the cell format to convert that
to "04/29/09" instead of "6/23/17" which is what it does now. Thank you in
advance for your assistance.

 

[Roger Govier]

Hi

Take a look at Chip Pearson's site
http://www.cpearson.com/Excel/DateTimeEntry.htm

Regards
Roger Govier