Results 1 to 5 of 5

Override date-format

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349

    Override date-format

    From a database I import to Excel a large table of mostly name codes.
    One of the codes is SEP01 for "Separator Type 1", but Excel thinks it is a date code and writes Sep-01 and stores the number 37135.
    Oother types are like NovaZeck-08, abbreviated NOV08 and you can imagine how Excel interprets that.

    Is there a way to avoid this confusion, eg a special set-up of Excel?


    NSV
    Last edited by nsv; 04-17-2009 at 02:15 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1