Hello all,
I have the below formula, but need the results to be capitalized. How can I have capitalization formula integrated into the formula I already have?
=DATE(Setup!D5,Setup!D7,1)
Thanks in advance.
Hello all,
I have the below formula, but need the results to be capitalized. How can I have capitalization formula integrated into the formula I already have?
=DATE(Setup!D5,Setup!D7,1)
Thanks in advance.
Try
=UPPER(TEXT(DATE(Setup!D5,Setup!D7,1),"dd/mmm/yyyy"))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
This worked perfectly. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks