+ Reply to Thread
Results 1 to 3 of 3

Why does my date appear as 1900 in excel when printing

  1. 01-31-2024, 07:32 AM #1
    GmanJP
    GmanJP is offline
    Registered User
    Join Date
    02-01-2023
    Location
    Blumenau, SC
    MS-Off Ver
    2019 Pro Plus
    Posts
    14

    Why does my date appear as 1900 in excel when printing

    I've seen some users report this problem with the "1900", but i didn't find anything specifically when printing.

    A colleague's computer is showing "1900", and on my computer, with the exact same spreadsheet, the date is correct.

    Appreciate any help.

    1900.pngexample2.xlsx2024.png
    Reply With QuoteRegister To Reply
  2. 01-31-2024, 10:16 AM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Why does my date appear as 1900 in excel when printing

    The 1900 date indicates zero. How are you setting up that footer? Is it today's date, the last save date, or something else?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 01-31-2024, 10:36 AM #3
    GmanJP
    GmanJP is offline
    Registered User
    Join Date
    02-01-2023
    Location
    Blumenau, SC
    MS-Off Ver
    2019 Pro Plus
    Posts
    14

    Re: Why does my date appear as 1900 in excel when printing

    I'm just going to the header and footer section and selecting the items I want to appear, as I indicated in the photo.

    WhatsApp Image 2024-01-31 at 11.35.10.jpeg
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. date pasted as 1/2/1900 in excel instead of 1/1/1900
    By ekkslatha in forum Excel General
    Replies: 4
    Last Post: 10-25-2014, 08:34 PM
  2. Macro for changing the date from 02-Jan-1900 to 01-Jan-1900
    By Lavanya Anandan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 07:08 AM
  3. How do I get Excel date to change from 1/1/1900?
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 05:05 PM
  4. [SOLVED] How do I get Excel date to change from 1/1/1900?
    By Macdad in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. How do I get Excel date to change from 1/1/1900?
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 05:05 AM
  6. [SOLVED] How do I get Excel date to change from 1/1/1900?
    By Macdad in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How do I get Excel date to change from 1/1/1900?
    By Macdad in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1