Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, BC
    Posts
    100
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Avoiding Dates in Excel (Excel 2003)

    Hi,

    Our database program at work exports delivery lists for newspaper routes in csv format. This is fine except in the case of some apartment numbers. Our delivery lists are grouped by street, so the "header" for a group would be the street name (e.g. Main St). The subscriber addresses are then listed below. If the address is a year (e.g. 1925) and the apartment number is between 1-12, the csv format shows the address as a date, with the result that route lists look like this (simplified):

    Main St
    Jan-25
    May-25
    Dec-25
    13-1925
    16-1925
    22-1925
    etc.

    I need apartments 1-12 to show up the same way the latter ones do. I've experimented with the various Options setting, but nothing seems to fix it. When I open the file with WordPad, the addresses are properly displayed as comma separated values, albeit with double quotes around each entry. I tried replacing the double quotes with single quotes hoping that Excel would then show just the address as is, but in this case the single quotes show up as visible, which we don't want on the list.

    Any ideas?

    Thanks,

    John

  2. #2
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Avoiding Dates in Excel (Excel 2003)

    Good afternoon

    I just tried using the same version as you and put in '12 1925 and '12-16 1925 and both show on the worksheet as you want without displaying the ' single quote (you don't need one at the end.

    Hope that helps

    teve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Avoiding Dates in Excel (Excel 2003)

    Try replacing the Double Quotes with Double Quotes and a space then bring into Excel. The leading space could stop Excel from converting. However, you will have a leading space in every address but there shoulld be no quotes.

    Regards,

    Tom Duthie

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

    Re: Avoiding Dates in Excel (Excel 2003)

    You can also try this:

    - Create a blank workbook in Excel.
    - Select column A.
    - Select Format | Cells and select Text format, then click OK.
    - Select cell A1.

    - Open the csv file in Notepad.
    - Press Ctrl+A then Ctrl+C to copy its contents.

    - Switch to Excel.
    - Press Ctrl+V to paste.
    - You can use Edit | Replace to get rid of quotes.

Posting Permissions

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