+ Reply to Thread
Results 1 to 2 of 2

stop changing data to date

  1. #1
    Sara
    Guest

    stop changing data to date

    When I type data ranging from 3-6 it automatically changes this to the date
    of March 6 and that's not what I want. How do I stop this insanity?!

  2. #2
    JE McGimpsey
    Guest

    Re: stop changing data to date

    either preformat the cell as Text (so that XL doesn't try to parse it),
    or prefix the data with an apostrophe to indicate to the parser that
    what follows is text:

    '3-6

    In article <[email protected]>,
    "Sara" <[email protected]> wrote:

    > When I type data ranging from 3-6 it automatically changes this to the date
    > of March 6 and that's not what I want. How do I stop this insanity?!


+ Reply to Thread

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