Menu

Number Format - Capitalize

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Don Guillett

Posts: n/a

Default

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 With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert [h]:mm sum total format to number format	Guy	Excel Worksheet Functions	1	August 5th 05 05:56 AM
Number format exactly the same, displays differently in some cells	eider	Excel Discussion (Misc queries)	1	July 29th 05 12:26 AM
Number format for Combobox	MBlake	Excel Discussion (Misc queries)	1	June 29th 05 03:25 AM
16 digit number wont keep alteration unless format cell to text	Croc001	Excel Discussion (Misc queries)	3	March 30th 05 09:12 AM
How do i change numbers in text format to number format?	Greg	New Users to Excel	1	December 14th 04 05:22 PM

All times are GMT +1. The time now is 05:19 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement