Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub Target = UCase(Format(Target, "MMM")) End Sub -- Don Guillett SalesAid Software "Josh O." wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
Is there anything I need to do?
"Don Guillett" wrote: right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub Target = UCase(Format(Target, "MMM")) End Sub -- Don Guillett SalesAid Software "Josh O." wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
You could use a font which only displays capital letters..... or with a formula in another cell =UPPER(TEXT(A1,"mmm")) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=522358 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
It didn't do anything.
"Josh O." wrote: Is there anything I need to do? "Don Guillett" wrote: right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub Target = UCase(Format(Target, "MMM")) End Sub -- Don Guillett SalesAid Software "Josh O." wrote in message ... 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
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. -- Big Rick "Don Guillett" wrote: Do as I said and any date such as 3/15 entered into any cell in column B will say MAR -- Don Guillett SalesAid Software "Josh O." wrote in message ... Is there anything I need to do? "Don Guillett" wrote: right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub Target = UCase(Format(Target, "MMM")) End Sub -- Don Guillett SalesAid Software "Josh O." wrote in message ... 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
if target.address= "$A$2" then
-- Don Guillett SalesAid Software "Big Rick" wrote in message ... 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. -- Big Rick "Don Guillett" wrote: Do as I said and any date such as 3/15 entered into any cell in column B will say MAR -- Don Guillett SalesAid Software "Josh O." wrote in message ... Is there anything I need to do? "Don Guillett" wrote: right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub Target = UCase(Format(Target, "MMM")) End Sub -- Don Guillett SalesAid Software "Josh O." wrote in message ... 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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
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 -- Big Rick "Don Guillett" wrote: if target.address= "$A$2" then -- Don Guillett SalesAid Software "Big Rick" wrote in message ... 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. -- Big Rick "Don Guillett" wrote: Do as I said and any date such as 3/15 entered into any cell in column B will say MAR -- Don Guillett SalesAid Software "Josh O." wrote in message ... Is there anything I need to do? "Don Guillett" wrote: right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub Target = UCase(Format(Target, "MMM")) End Sub -- Don Guillett SalesAid Software "Josh O." wrote in message ... 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. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format - Capitalize
Glad it worked for you.
-- Don Guillett SalesAid Software "Big Rick" wrote in message ... 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 -- Big Rick "Don Guillett" wrote: if target.address= "$A$2" then -- Don Guillett SalesAid Software "Big Rick" wrote in message ... 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. -- Big Rick "Don Guillett" wrote: Do as I said and any date such as 3/15 entered into any cell in column B will say MAR -- Don Guillett SalesAid Software "Josh O." wrote in message ... Is there anything I need to do? "Don Guillett" wrote: right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub Target = UCase(Format(Target, "MMM")) End Sub -- Don Guillett SalesAid Software "Josh O." wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Number format for Combobox | Excel Discussion (Misc queries) | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |