+ Reply to Thread
Results 1 to 3 of 3

referencing date from another spreadsheet changes format

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    Midland, TX
    MS-Off Ver
    Excel 2010
    Posts
    37

    referencing date from another spreadsheet changes format

    I am referencing the date in long format from sheet Information and placing in a formula under sheet Contract.
    =("The scope of work will begin on " & Information!C3)

    The date is August 30, 2017 on the Information sheet and is returning as 42977 on the Contract sheet.

    How do I fix this?

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: referencing date from another spreadsheet changes format

    you need to use the text function

    ="the scope of the work will begin on " & text(Information!C3, "mmmm dd, yyyy")

  3. #3
    Registered User
    Join Date
    07-10-2012
    Location
    Midland, TX
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: referencing date from another spreadsheet changes format

    Perfect! Thank you!

+ 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] Sumif referencing another cell for criteria (date and time format)
    By Baldowsky in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2014, 05:01 AM
  2. [SOLVED] Date Format changes from Userform to Spreadsheet
    By Sorjas in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-23-2014, 06:24 AM
  3. Updating Date in Spreadsheet to table in SQL in UK date format
    By nickymac in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-27-2014, 02:19 PM
  4. [SOLVED] Userform date entered in UK format but showing in US Format in spreadsheet
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-23-2013, 01:59 PM
  5. Date format on UserForm changes on Spreadsheet
    By darthelvis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 05:41 PM
  6. Date Format when writing back to Spreadsheet
    By Shazz in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 02-09-2012, 11:14 AM
  7. one column on my excel spreadsheet will NOT format the date
    By mrm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2006, 09:15 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