Re: Date Format Conversion?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Tue, 11 Oct 2005 13:23:20 -0500, Chris in Nebraska <cpultz2@xxxxxxxxx>
wrote:

>
>I have a tab delimited text file with a column of dates. I copied and
>pasted a selection of them below as a reference, there are in reality
>over 35,000 rows of these dates.
>
>These text dates must be converted to the following date format and
>saved back into a text file as such:
>
>mm/dd/yyyy
>
>That includes leading zeroes in months and dates. E.g. 01/01/1999
>
>To complicate matters, I need to explain the process to others.
>
>Does anyone even know where I should begin?
>
>THANK YOU,
>- Chris
>
>+++++++++++++++++++++++++++
>
>
>9031989
>8131990
>9201989
>1271990
>10291989
>1081990
>3041990
>10051989
>4191990
>10171989
>4241990
>12181989
>11061989
>8291989
>11021989
>12291989
>10181989
>5151990
>11221989
>9111989
>9111989
>5231990
>11211989
>7271989
>10301989
>5241990
>6081990
>9211989
>10021990
>

If your data is in A1:A35000

B1: =TEXT(A1,"00\/00\/0000")

Fill down to B35000

Then select column B
Edit/Copy
Edit/Paste Special/Values

Delete Column A

--ron
.

Relevant Pages

  • Integer Linear Programming
    ... I need a paper/book as reference for my master's thesis. ... Chris ... Prev by Date: ...
    (sci.math)
  • Integer Linear Programming
    ... I need a paper/book as reference for my master's thesis. ... Chris ... Prev by Date: ...
    (comp.programming)
  • Good used book
    ... As an occasional user of excel ive forgotten more than I can remember ... and therefore need to buy a good big book for reference. ... Chris ... Prev by Date: ...
    (microsoft.public.excel)
  • SS arrives in Sydney from WA
    ... Nice selection of sticks. ... family have a very Merry Christmas. ... Chris ... Prev by Date: ...
    (alt.smokers.cigars)