software

I have a worksheet (in 2000) that was sent to me. The information in the
worksheet was culled from an Access database that I have no access to, and
saved to Excel.

There are several columns of dates that came over as quot;generalquot; in this format:
20031125.
I want to quickly convert this into the proper date format of 11/25/03, but
I cannot seem to figure out a quick method to do it in Excel 2000.
HELP!

Do you ALWAYS have four digits for the year, and two each for month and day?
If so, I'd use Data gt; Text to Columns, with the delimited option to break
each yyyymmdd into its components, then =date(a1,b1,c1) to form the date.
Finally copy/ paste special values to lock in the results.

quot;Russell-stanelyquot; wrote:

gt; I have a worksheet (in 2000) that was sent to me. The information in the
gt; worksheet was culled from an Access database that I have no access to, and
gt; saved to Excel.
gt;
gt; There are several columns of dates that came over as quot;generalquot; in this format:
gt; 20031125.
gt; I want to quickly convert this into the proper date format of 11/25/03, but
gt; I cannot seem to figure out a quick method to do it in Excel 2000.
gt; HELP!

Yes, the sheet always has 4 digits for year and two each for month and date.
I don't understand what you mean to use Datagt;text to columns, etc. etc. Is
this a formula or a fomatting condition? Sorry, could you be more specific
on how to do this?

Thanks!

quot;bpeltzerquot; wrote:

gt; Do you ALWAYS have four digits for the year, and two each for month and day?
gt; If so, I'd use Data gt; Text to Columns, with the delimited option to break
gt; each yyyymmdd into its components, then =date(a1,b1,c1) to form the date.
gt; Finally copy/ paste special values to lock in the results.
gt;
gt; quot;Russell-stanelyquot; wrote:
gt;
gt; gt; I have a worksheet (in 2000) that was sent to me. The information in the
gt; gt; worksheet was culled from an Access database that I have no access to, and
gt; gt; saved to Excel.
gt; gt;
gt; gt; There are several columns of dates that came over as quot;generalquot; in this format:
gt; gt; 20031125.
gt; gt; I want to quickly convert this into the proper date format of 11/25/03, but
gt; gt; I cannot seem to figure out a quick method to do it in Excel 2000.
gt; gt; HELP!

I think you can do what you want all in one step:

Select the quot;datequot; cells
Datagt;Text-to-columns
Delimited...Click Next
(Doesn't matter what the delimiter is)...Click Next
Click the Date option and set the dropdown to YMD...Click Finish
That should turn those numbers into dates.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Russell-stanelyquot; wrote:

gt; I have a worksheet (in 2000) that was sent to me. The information in the
gt; worksheet was culled from an Access database that I have no access to, and
gt; saved to Excel.
gt;
gt; There are several columns of dates that came over as quot;generalquot; in this format:
gt; 20031125.
gt; I want to quickly convert this into the proper date format of 11/25/03, but
gt; I cannot seem to figure out a quick method to do it in Excel 2000.
gt; HELP!

quot;bpeltzerquot; wrote:
gt; .. If so, I'd use Data gt; Text to Columns,
gt; with the delimited option to break
gt; each yyyymmdd into its components ...

Perhaps with Data gt; Text to Columns there's no need to break further ? Just
select the source col of quot;datesquot;, click Data gt; Text to Columns, click Next gt;
Next, and in Step 3 (under quot;Column data formatquot;): check quot;Datequot;, select quot;YMDquot;
from the droplist, click Finish. Then just format the converted col as
quot;Datequot; (to taste).
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
So very cool!
Thanks for the help!

quot;Ron Coderrequot; wrote:

gt; I think you can do what you want all in one step:
gt;
gt; Select the quot;datequot; cells
gt; Datagt;Text-to-columns
gt; Delimited...Click Next
gt; (Doesn't matter what the delimiter is)...Click Next
gt; Click the Date option and set the dropdown to YMD...Click Finish
gt; That should turn those numbers into dates.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Russell-stanelyquot; wrote:
gt;
gt; gt; I have a worksheet (in 2000) that was sent to me. The information in the
gt; gt; worksheet was culled from an Access database that I have no access to, and
gt; gt; saved to Excel.
gt; gt;
gt; gt; There are several columns of dates that came over as quot;generalquot; in this format:
gt; gt; 20031125.
gt; gt; I want to quickly convert this into the proper date format of 11/25/03, but
gt; gt; I cannot seem to figure out a quick method to do it in Excel 2000.
gt; gt; HELP!