Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Illinois
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insterting Dates into a text cell (2000/SR1)

    I am trying to add a date to a text box. The date is pulled out of a date cell. That way I can code a bunch of cells something like "As of DATE" where date is pulled out of a single cell. When I try it now, I get a number inserted. Attached is a simple example.

    Thanks,
    Justin
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Insterting Dates into a text cell (2000/SR1)

    Try the following formula in A2 :

    <big>="As of " & TEXT(B1,"mm/dd/yyyy")</big>

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •