Would think all that is needed is select the cell, right click-"Format Cells"
Click on Number tab
Select Date, in Category
From the Type list, select the format desired
Select Custom, in Category
Create a formatting code to your liking
_________________ This message was edited by stevebausch on 2002-10-12 07:02
One more. It appears that the entry is text. Would you check it by
No need for the above.
(1.) Select all the cells with entries that you want to convert.
(2.) Activate Date|Text to Columns.
(3.) Choose Delimited.
(4.) Click Next until you are in step 3 of Wizard.
(5.) Check Date for Column Data Format.
(6.) Click Finish.
Aladin This message was edited by Aladin Akyurek on 2002-10-12 07:06