S smith70 Dec 2, 2009 #1 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?
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?
M Mike H Dec 2, 2009 #2 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
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
S smith70 Dec 2, 2009 #3 Perfect!.... thanks, it worked! Mike H said: 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 Click to expand...
Perfect!.... thanks, it worked! Mike H said: 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 Click to expand...
