I wont to use all captial letters in my spread sheet is there a font or way to do this.
I wont to use all captial letters in my spread sheet is there a font or way to do this.
use =upper()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The button above the Shift key on your keyboard - CAPS LOCK - should do the trick.
- Moo
You need fonts like these:
http://www.fonts101.com/search/small+cap
Microsoft Word has a font setting for "all caps" so that even if you type lowercase letters, they are displayed as caps. However, Excel does not have this formatting option. This is different than "small caps" fonts as referenced above. Maybe there is an "all caps" font but I can't find one. One way around this would be to use a macro to convert cells to all caps every time you type; crude but effective.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks