I'm creating a subject line for email. I'm using different cells to create the subject.
="_ "&+B1&"_ "&+G1&"_ "&I1
The cell G1 holds the date and I want to use the date within the subject line. What I need to know is how to make this date show as a date and not a number in the cell where the above formula is located. I've tried to format the cell the same as cell G1 without success.
something like:
="_ "&+B1&"_ "&+Text(G1,"dd/mm/yy")&"_ "&I1
where "dd/mm/yy" is the format you want...you can change to suit.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you! That took someone 8min to figure out? That was exactly what I was looking for.
It took actually less than 10 seconds to figure out....the 8 minutes includes time before your post was seen after you posted it and time to actually reply....Originally Posted by Tortus
Thank you! That took someone 8min to figure out? That was exactly what I was looking for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks