+ Reply to Thread
Results 1 to 5 of 5

stop changing numbers to date

  1. #1
    Registered User
    Join Date
    10-11-2018
    Location
    Barrie, ON
    MS-Off Ver
    excel 2010
    Posts
    2

    stop changing numbers to date

    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. I am unable to change format to text (it is not changing to number from date).

    I am not able to attache file. so i am pasting my content.



    DIVISIONID DIVISIONID DIVISIONNAME
    0901-Jan 01-Jan
    0901-Feb 01-Feb
    0901-Mar 01-Mar
    0901-Apr 01-Apr
    0901-May 01-May
    0901-Jun 01-Jun
    0901-Jul 01-Jul
    0901-Aug 01-Aug
    0901-Sep 01-Sep
    0901-Oct 01-Oct
    0901-Nov 01-Nov
    0901-Dec 01-Dec
    09Jan-13 Jan-13
    09Jan-14 Jan-14
    09Jan-15 Jan-15

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: stop changing numbers to date

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: stop changing numbers to date

    Your post does not comply with Rule 3 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    Please make sure to include the full link, so that other members will be permitted to continue helping you

    Note that if you have fewer than 10 posts, you may need to type the link, or past it in pieces (or ask a mod to do that for you)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    10-11-2018
    Location
    Barrie, ON
    MS-Off Ver
    excel 2010
    Posts
    2

    Re: stop changing numbers to date

    I am unable to fix this issue. any help is appreciated.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: stop changing numbers to date

    Read post 3 please, and comply

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date Format Keeps Changing - why and how to stop it?
    By JasonMcQueen in forum Excel General
    Replies: 1
    Last Post: 07-22-2016, 07:50 AM
  2. [SOLVED] Stop Excel from changing numbers to dates in CSV file
    By Curt L. in forum Excel General
    Replies: 3
    Last Post: 11-04-2013, 12:26 PM
  3. Stop Randomized numbers from changing
    By jsamuelshn in forum Excel General
    Replies: 9
    Last Post: 10-21-2010, 06:51 PM
  4. How to stop Changing Numbers to Dates
    By luu980 in forum Excel General
    Replies: 3
    Last Post: 09-28-2008, 11:30 PM
  5. How do I stop Excel from changing numbers into a date?
    By Buckwildbill in forum Excel General
    Replies: 1
    Last Post: 03-07-2005, 04:06 AM
  6. stop changing data to date
    By Sara in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-09-2005, 04:06 PM
  7. Replies: 1
    Last Post: 01-05-2005, 06:06 PM

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