Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting in Concatenated Cell (Office 2003)

    I have a simple issue that I can not seem to solve. I want to create a cell that says: "Today is 5-Apr-06". I can do side-by-side cells with Today is and =today(), but in the sheet I am working on, I need to put them both in the same cell. So...

    I tried to do "=("Today is " & TODAY())", this yields "Today is 38812". How can I format the entries so that I can do something like BOLD the "Today is", and make the date a date in my desired format? Is it a matter of putting these things into other "hidden" cells and then concatenating those hidden cells?

    Thanks!

    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting in Concatenated Cell (Office 2003)

    You can use

    ="Today is "&TEXT(TODAY(),"d-mmm-yy")

    to display the date in the desired format. It is not possible, however, to apply formatting font formatting such as bold to part of a formula.

Posting Permissions

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