Display =TEXT as uppercase

[tomot]

Hello,

First time poster, please be gentle.
Working with Excel 2007.

I'm trying to have a cell display the day of the week when a date in entered in another cell. I'm using =TEXT(B4,"DDDD") which works but the day is in proper case.

I tried using the code below that I found on another site. It works, but only once.
If use a different date it does not update the cell with the correct day of the week.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Value = UCase(Target.Value)
Application.EnableEvents = True
End Sub


Appreciate any help.

 

[Mike LH]

Hi,

Welcome to the forum. Does this do what you want?


=UPPER(TEXT(B4,"DDDD"))

 

[tomot]

That worked, thanks for the quick response. I'm still a bit new to excel and greatly appreciate the help.

 

[Mike LH]

That worked, thanks for the quick response. I'm still a bit new to excel and greatly appreciate the help.

You're welcome, be sure to come back if you have any further questions.