date formatting a cell

[Guest]

When I use the date formatting in a cell i.e. m/d/yy and enter my numbers i.e 2604, I get 2/16/07. Can you help me

 

[Frank Kabel]

Hi
you have to enter the date with delimiters. so you have to enter 2/6/04
If you want Excel to automatic convert numbers you have to use VBA.
Have a look at
http://www.cpearson.com/excel/DateTimeEntry.htm
for an example event procedure

Frank

 

[Frank Kabel]

Hi
that is the way Excel handles date inputs. As Excel stores dates
internally as numbers it does not know if you want to enter the a date
as MMDDYYYY or the integer value for a date (x days after 0.0.1900). So
if you enter 021104 excel interprets this as the 21104th day after
0.0.1900 ´(that is 10/11/1957)

Therefor I provided you the link to a VBA solution which will be
triggered by your entries and will do the conversion. Just try it

Frank

 

[Dave Peterson]

Another way that might work for you if your dates are in a single column:

Format the "date" cells as text first.

Enter your dates as 8 digits: 01231983

Then select this range and do Data|Text to columns
choose fixed width, remove any guesses that xl may have made.
choose mdy as the format.

 

[PegL]

If you can enter 2/6/04 as 20604 instead of 2604, you
could use custom formatting, e.g., #0\/00\/00. Excel
won't see this as a date, however.

-----Original Message-----
What I want to do is format a cell to display numbers

i.e. 021104 as a date i.e. 02/11/04. When I go to
format, cell, numbers and highlight date, the cell does
not convert the numbers to show as a date unless I put in
the /, which seems to defeat the purpose of date
formatting.