Formatting in Concatenated Cell (Office 2003)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote