Converting Number to Date
You state that the format you download is MMDDYY,
BUT ...
You then give as an example for May 31,2007 - 53107
Are you *sure* that you don't get
053107
which would be MMDDYY format?
If you made a typo, and you *do* download 053107,
then you can use Text To Columns to easily transform those numbers to XL
recognizable dates.
Select the column of data, then from the Menu Bar,
<Data <Text To Columns <Next <Next
Click on "Date", and make sure that "MDY" is displayed in the box.
Then <Finish
You now have XL "legal" dates which you can format to any date style you
wish.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"billbrandi" wrote in message
...
I have a file that I regularly download from a mainframe system. In the
file, dates come across as numbers in a MMDDYY format (example, May 31,
2007
come across as 53107; November 15, 2007 is 111507).
How can I change these numbers to a correct date format in Excel?
Thanks
Bill
|