+ Reply to Thread
Results 1 to 11 of 11

Showing Created Date of Document

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,792

    Re: Showing Created Date of Document

    Excel isn't Word. Word is designed for the production of printed documents (letters, etc.), so being able to do that there makes sense. Excel is NOT designed for creating such documents. It's a spreadsheet for number crunching.

    If you want a creation date when you start a new file, then you have two choices: either type it manually or add some VBA code to convert a cell containing =NOW() or =TODAY() to a text value when you save the file.

    It might help to tell us what your goal is here: what are you using Excel for?

    TODAY() vs NOW() - https://www.accountingweb.com/techno...day-versus-now
    Last edited by AliGW; 02-22-2020 at 02:11 PM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  2. #2
    Registered User
    Join Date
    02-22-2020
    Location
    Canada
    MS-Off Ver
    office 2016 Mac
    Posts
    6

    Re: Showing Created Date of Document

    thank you for your prompt reply.

    i decided to put all my data into Excel because I can separate it all by columns and then do a variety of sorting column contents....
    not easily achieved in word and I don't even know if I created a table in word
    whether that would achieve the same thing.

    will just have to suck it up and enter creation date each time.
    Last edited by lori2020; 02-22-2020 at 02:28 PM.

+ 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. Copy Formulas from 'Formulas' Sheet into Data Table Columns
    By Jonny757 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2020, 08:18 PM
  2. Replies: 0
    Last Post: 06-08-2016, 10:53 AM
  3. [SOLVED] Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas
    By Mattdim805 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2013, 04:11 PM
  4. Replies: 2
    Last Post: 10-23-2013, 09:32 AM
  5. Divide selected data into groups, use formulas on data, the output results
    By papuanewguinea in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2013, 06:04 PM
  6. Replies: 1
    Last Post: 05-04-2013, 06:42 PM
  7. Replies: 1
    Last Post: 05-03-2013, 11:38 AM

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