I would like to add 'Run Date: ' in front of a command that reads a date off
of a data sheet. How do I add text to a command?

Hi,

If you add text you will also have to re=format the date in the formula

="Run Date " & TEXT(Sheet2!A1,"dd/mm/yyyy")

Mike

"smith70" wrote:

I would like to add 'Run Date: ' in front of a command that reads a date off
of a data sheet. How do I add text to a command?

Perfect!.... thanks, it worked!

"Mike H" wrote:

Hi,

If you add text you will also have to re=format the date in the formula

="Run Date " & TEXT(Sheet2!A1,"dd/mm/yyyy")

Mike

"smith70" wrote:

I would like to add 'Run Date: ' in front of a command that reads a date off
of a data sheet. How do I add text to a command?