Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Change Text (2003)

    This, in a way is linked to post <post#=692,908>post 692,908</post#>. I've sorted out the import problem,(I hope) but now I have another. Because in one of the columns we type the date, but this is not always applicable, so people type in 'n/a'. For this reason, the column has to be text. We decided on the format of 22/02/08, so I changed all the dates which were wrong (10207,01.02.07,1207 ) into the right format. I've now been told, that the dates can only be imput as 22.02.08, as there is no / on the equipment. How can I change all the dates I've changed to the_/_/_ format, back to _._._

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change Text (2003)

    Is the date column formatted as text? If so:
    - Select the column
    - Select Edit | Replace... or press Ctrl+H.
    - Enter / in the Find what box.
    - Enter . in the Replace with box.
    - Click Replace All.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Change Text (2003)

    Thanks Hans. I was under the impression that would only work with strings. Don't know why. Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •