Thread: Date Format

Hi

can anybody help me to retain the date format when I combine some other data with the date in a single cell. I am not getting the same date format when the date field is combined with other text data.

Attached is a sheet with example.

I would like it without VB if possible.

Thanks for helping

Pal

=F7&" :"&F8&", "&G7&" :"&G8&", "&H7&": "&TEXT(H8,"dd-mmm-yy")


Regards, TMS

Can I also highlight the date field as BOLD in the same cell

Not that I am aware. The custom format doesn't appear to have that capability.


Regards, TMS