HOW I USE CAPITAL LETTERS FROM THE TOOLBAR?

[Fernanda]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

CAN NOT CHANGE THE LETTERS (ALL TO CAPITAL LETTERS) FROM MY CELLS. Actually, I ca not find thisservice at toolbar.

 

[Fernanda]

I CAN NOT CHANGE THE LETTERS (ALL TO CAPITAL LETTERS) FROM MY CELLS. Actually, I can not find this service at toolbar.

 

[Jim Gordon MVP]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

CAN NOT CHANGE THE LETTERS (ALL TO CAPITAL LETTERS) FROM MY CELLS. Actually, I ca not find thisservice at toolbar.

Hi,

Excel's forte is not word processing, it's working with formulas and data.

So switch gears a little bit and think of using a cell formula instead
of a button on a toolbar.

There's a worksheet function called UPPER. For details about how to use
UPPER, just search Excel's help system on the topic UPPER.

In the next version of Office you'll be able to make a uppercase toolbar
button of your own via VBA.

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9

 

[CyberTaz]

And for good reason - All caps is *horrendously* difficult to read & equally
difficult to deal with in most other respects. If you can provide a
description of what you actually need to accomplish there may be some
alternatives. Otherwise I can only suggest using the Caps Lock as you type.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Phillip Jones, CET]

In the Computer world its the equivalent to Screaming at the top of your
longs like you about to blow a Gasket.

And for good reason - All caps is *horrendously* difficult to read & equally
difficult to deal with in most other respects. If you can provide a
description of what you actually need to accomplish there may be some
alternatives. Otherwise I can only suggest using the Caps Lock as you type.

Regards |:>)
Bob Jones
[MVP] Office:Mac

--
------------------------------------------------------------------------
Phillip M. Jones, CET |MEMBER:VPEA (LIFE) ETA-I, NESDA,ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>