Number Format - Capitalize

[Guest]

Is there a way to get a number format to show capital letters?

For example, I want to display 3/14/2006 as "MAR". I can get it to display
as Mar, but my boss wants it to appear as capital letters.

 

[Don Guillett]

right click sheet tab>view code>insert this>

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
Target = UCase(Format(Target, "MMM"))

End Sub

 

[Guest]

Is there anything I need to do?

right click sheet tab>view code>insert this>

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
Target = UCase(Format(Target, "MMM"))

End Sub

 

[daddylonglegs]

You could use a font which only displays capital letters.....

or with a formula in another cell

=UPPER(TEXT(A1,"mmm"))

 

[Guest]

It didn't do anything.

Is there anything I need to do?

 

[Don Guillett]

Do as I said and any date such as 3/15 entered into any cell in column B
will say MAR

 

[Guest]

I quite like this.
Please can you tell me what to change to only have this in one cell. (say A2)

Thanking you in anticipation.
Your help is and always has been very much appreciated.

 

[Don Guillett]

if target.address= "$A$2" then

 

[Guest]

Thank you for replying and for quick responce.
This did work but had to change the = to <>.
I must be getting better. I wouldn't of been able to work that one out a
couple of months ago.

Thank you again

 

[Don Guillett]

Glad it worked for you.