+ Reply to Thread
Results 1 to 3 of 3

number keep being formatted as date

  1. #1
    Registered User
    Join Date
    10-05-2005
    Posts
    2

    Exclamation number keep being formatted as date

    Hi:

    I'm a newbie so forgive me if this question has been answered. I couldn't find much with the search option.

    Okay here's the problem.

    I want to enter this: 1-2 into a cell but Excel keep turning it into 2-Jan. How do I turn this off?

    the 1-2 is just a designation of point 1 to point 2.

    Thank you for helping.

  2. #2
    Registered User
    Join Date
    05-28-2004
    Posts
    21
    You can format the cells to text and then you should be able to enter the information as 1-2 and get the result expected. Simply select the destination cells an go to Format>Cells>Number>Text. Hope this is what you are looking for.

  3. #3
    Registered User
    Join Date
    10-05-2005
    Posts
    2

    Thumbs up thank you nuver

    this is exactly what I was looking for. your solution is right on the spot!

+ 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