Morning all,
Looking for a little help with the following formula =CONCATENATE("August 07 -",TODAY()," Evening Instructor") After entering this formula today is displayed as a serial number. I'd like it to display as current month/current day/current year (11/28/08)
The help is always appreciated.
Last edited by scaffdog845; 11-28-2008 at 12:18 PM. Reason: Resolved
You need to use TEXT function, something like this
="August 07 -"&TEXT(TODAY(),"mm/dd/yy")&" Evening Instructor"
Thanks from an Excel guru wanna be. Learn a little more every day working with Excel.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks