G
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
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
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
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
F
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
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
D
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.
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.
P
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.
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.
could use custom formatting, e.g., #0\/00\/00. Excel
won't see this as a date, however.
i.e. 021104 as a date i.e. 02/11/04. When I go to-----Original Message-----
What I want to do is format a cell to display numbers
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.