View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Help with cell formatting

First, select the column and select the cell format to be text
Second, touch the CAPS LOCK key
third, type
--
Gary's Student


"Fonz" wrote:

I would like to format a column of cells to allow for me to enter text and
for the cells to automatically make the txt ini all capital letters. HOw can
this be done please? Thanks in advance.