Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Help - Banging my head against a brick wall

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have designed a search page for our company Intranet site. Employees at the various branches can search on product codes and download them into an excel sheet. The information from the browser is downloaded in csv format. The problem is that in one of the columns some of the codes start with (02-), Excel then decides to turn this into a date. Is there any way that this option can be turned off all together. I know that if the column is formatted as a text column and the codes are pasted into that column then there ok but obviously the whole point is that they can just download the page, open it up and the information is there without any messing.

    Any help would be much appreciated

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Surrey, United Kingdom
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Gaz,

    As long as the cells you are importing the data into are formatted as text, Excel should not autoformat as a date.

    If you do need to stop a text string from getting converted to a date i.e. "1-31", add an apostrophe ' before the string, e.g. " '1-31 ".

    Hope this helps,

    Nibbles

    [ This Message was edited by: Nibbles on 2002-05-10 02:42 ]

    [ This Message was edited by: Nibbles on 2002-05-10 02:43 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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