Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trickywoo
 
Posts: n/a
Default Format Excel column as Upper Case without use of UPPERCASE formul

In Word a table column can be set to display in Upper Case regardless of case
in use during input. Is this available in Excel? The formula UPPERCASE
wastes a column and adds unnecessary complications.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default Format Excel column as Upper Case without use of UPPERCASE formul

Excel has no "uppercase view" of a font. But there are macros that can
change the case to uppercase either all at once or during data entry.
http://www.officearticles.com/excel/...ft_exce l.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out: www.ExcelUserConference.com

"Trickywoo" wrote in message
...
In Word a table column can be set to display in Upper Case regardless of
case
in use during input. Is this available in Excel? The formula UPPERCASE
wastes a column and adds unnecessary complications.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Number format Mani K Excel Discussion (Misc queries) 2 December 28th 05 11:01 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
EXCEL:NUMBER TO GREEK WORDS vag Excel Worksheet Functions 1 June 15th 05 05:57 PM
reminder notifications in a column L Mieth Excel Discussion (Misc queries) 6 June 10th 05 11:00 AM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


All times are GMT +1. The time now is 06:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"