Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2010 : Formula answer to be in all caps 1

Status
Not open for further replies.

pendle666

Technical User
Jan 30, 2003
295
GB
Hello

Cell F1 contains a date entered by a user, say 15/09/15

Cell C1 has a formula to give the day of the week =TEXT(F1,"DDD")

which gives me Tuesday, however I want TUESDAY in all capitals. I know there is a formula command UPPER but I'm not sure where it goes and several attempts haven't given me what I wanted.

Many thanks



thank you for helping

____________
Pendle
 
Hi

I've tried that but it comes up with the actual formula in the cell rather than the result. The "show formula" button isn't highlighted, but the cell is formatted as text.

thank you for helping

____________
Pendle
 
Since you'll need to convert the text to a value, try using the following:
Code:
=UPPER(TEXT(VALUE(F1),"DDDD"))
 
Excellent - thank you!

thank you for helping

____________
Pendle
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top