+ Reply to Thread
Results 1 to 4 of 4

Displaying Cell Date with "&" in another Cell

  1. #1
    Forum Contributor
    Join Date
    06-29-2008
    Location
    Grand Rapids, MI
    MS-Off Ver
    Office 2010
    Posts
    127

    Displaying Cell Date with "&" in another Cell

    Hi folks...

    I'm trying to get excel to display a quote, plus a cell's text/value... the problem I am having is that the format is a date, and it ends up showing something like 37896 instead of 11/25/2008 (those are examples, not actuals)

    Here's the code:
    copy to clipboard
    Please Login or Register  to view this content.
    A63 is an Hlookup that references which cell is the first to say "insufficient" and checks down a few lines for the date.

    Thanks!
    Last edited by robert_shindorf; 12-18-2008 at 11:40 AM.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    18,682
    replace
    "Warning, Cash Flow will become unsustainable by "&A63

    "skint by "&text(A63,"dd/mm/yyyy")
    where a63 is date
    Last edited by martindwilson; 12-18-2008 at 10:13 AM.

  3. #3
    Forum Contributor
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    the cell with the date in is returning thate date as a number, if you want it to appear as a date replace A63 with something like

    text(A63,"dd/mm/yy")

    depending on the datre format you require

    Regards

    DAv

  4. #4
    Forum Contributor
    Join Date
    06-29-2008
    Location
    Grand Rapids, MI
    MS-Off Ver
    Office 2010
    Posts
    127
    got it, thanks, i new it was simple, i just never had to use that specific function before.

    Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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