Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    date to text (2000)

    A2 being the Date B2 is a box # and C2 is the # of Env I put this formula in D2
    =MONTH(A2)&",Box "&B2&",Env# "& C2
    the Result is 8,Box 1,Env# 1
    I would like it to read Aug 2006, Box 1,Env# 1
    Or it could be 8 2006
    Thanks for any help

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: date to text (2000)

    Hi there

    Try:

    =TEXT(A2,"mmm yyyy")&",Box "&B2&",Env# "& C2
    Jerry

Posting Permissions

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