Text in a command

S

smith70

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

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

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command code 2
Excel 2007 size of text in command button 1
output to the same line in a Text file? 2
GNU NANO a useful basic text editor. 3
Date command in Excel headers 10
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
The Beginner’s Guide to Nano, the Linux Command-Line Text Editor 3
External Data Toolbar permanently greyed out. 7

Top