Results 1 to 7 of 7

Autofilling date but for 1900s

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2024
    Location
    Spain
    MS-Off Ver
    MS Office 365
    Posts
    3

    Autofilling date but for 1900s

    Hi!
    I'm quite new to this, so excuse me if my explanations aren't very clear.

    So, basically I have a small problem. As you know, when you type "8/1/24" in a cell (in a dd/mm/yy format) Excel can automatically convert it into "8/1/2024" (now, dd/mm/yyyy). However, I'm working with dates from the past century, the 1900s. Therefore, I would like that Excel recognized that "24" from the year not as 2024, but as 1914; so it would outcome "8/1/1924" automatically.

    Thanks!

    M.

    [I'm using MS Office 365]

    Edit: Instead of "...from the year not as 2024, but as 1914." I meant "...from the year not as 2024, but as 1924."
    Last edited by mwerner; 01-08-2024 at 11:48 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Date on the graph show as 1900s - how to correct it
    By hassanm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2017, 11:28 AM
  2. [SOLVED] Autofilling cell with todays date, and some SUMIFS configuration
    By horsefish01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2015, 08:47 PM
  3. Autofilling VBA
    By Laylow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2011, 01:48 PM
  4. Autofilling a date from one cell to the next cell on its right
    By henderg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-27-2010, 08:21 AM
  5. Date Function giving dates from early 1900s
    By nhrav in forum Excel General
    Replies: 4
    Last Post: 07-25-2008, 02:03 PM
  6. Autofilling data
    By impala096 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-13-2008, 02:47 PM
  7. Autofilling Date AND Time in Column
    By mcmitchell in forum Excel General
    Replies: 1
    Last Post: 01-13-2005, 03:04 PM

Tags for this Thread

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