View Single Post
  #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.