Results 1 to 4 of 4

Thread: stop changing numbers to date

  1. #1
    Neophyte ramjee's Avatar
    Join Date
    Oct 2018
    Posts
    2
    Articles
    0
    Excel Version
    MS Excel 2010

    stop changing numbers to date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I am looking to stop changing numbers to date. I am not able to change with options provided. I have attached file. could you please guide what I am missing.


    1. Select the cells that youíll enter numbers into.
    2. Press Ctrl + 1 (the 1 in the row of numbers above the QWERTY keys) to open Format Cells.
    3. Select Text, and then click OK.

    If you only have a few numbers to enter, you can stop Excel from changing them into dates by entering:

    • A space before you enter a number. The space remains in the cell after you press Enter. (See Notes)
    • An apostrophe (Ď) before you enter a number, such as í11-53 or Ď1/47. The apostrophe isnít displayed in the cell after you press Enter.
    • A zero and a space before you enter a fraction such as 1/2 or 3/4 so that they donít change to 2-Jan or 4-Mar, for example. Type 0 1/2 or 0 3/4. The zero doesnít remain in the cell after you press Enter, and the cell becomes the Fraction number type.
      Notes:

      • We recommend using an apostrophe instead of a space for entering data if you plan on using lookup functions against the data. Functions like MATCH or VLOOKUP overlook the apostrophe when calculating the results.
      • If a number is left-aligned in a cell that usually means it isnít formatted as a number.
      • If you type a number with an ďeĒ in it, such as 1e9, it will automatically result in a scientific number: 1.00E+09. If you donít want a scientific number, enter an apostrophe before the number: Ď1e9
      • Depending on the number entered, you may see a small green triangle in the upper left corner of the cell, indicating that a number is stored as text, which to Excel is an error. Either ignore the triangle, or click on it. A box will appear to the left. Click the box, and then select Ignore Error, which will make the triangle go away.

    Attached Files Attached Files

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,012
    Articles
    0
    Excel Version
    Office 365 Subscription
    CROSS POST

    This question has been posted in at least one other forum.
    Do not post any further responses in this thread until a link has been provided to these cross posts.

    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

    This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
    Please update your original post to include the link(s).
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte ramjee's Avatar
    Join Date
    Oct 2018
    Posts
    2
    Articles
    0
    Excel Version
    MS Excel 2010
    I am unable to fix this issue. any help is appreciated.

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,469
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please provide links to your cross post(s) as requested before any more help can be given. As you do not have 5 posts yet insert links as text
    Thank you Ken for this secure forum.

Posting Permissions

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