+ Reply to Thread
Results 1 to 2 of 2

Excel keeps changing cell formatting to date

  1. #1
    Registered User
    Join Date
    12-25-2014
    Location
    Jerusalem
    MS-Off Ver
    XP
    Posts
    23

    Excel keeps changing cell formatting to date

    Hi,

    Both when I open a file with lists of numbers (e.g. 1253746) and when I copy and paste numbers into cells, excel automatically changes it to a date format.

    Is there a setting to change this I don't have to "format cells" each time it happens?

    Thanks

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Excel keeps changing cell formatting to date

    maybe you upload The File?

+ 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. [SOLVED] Changing the colour of a cell in direct relation to the date within Excel 2007
    By PTSO in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2014, 08:56 AM
  2. Changing pivot table date formatting
    By DANDERSEN in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-22-2013, 05:59 PM
  3. Replies: 3
    Last Post: 05-01-2009, 08:53 AM
  4. Replies: 2
    Last Post: 11-02-2007, 12:03 PM
  5. [SOLVED] Changing cell contents so that Excel recognises it as a date
    By Mifty in forum Excel General
    Replies: 4
    Last Post: 12-09-2005, 06:55 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