View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you could use a custom validation. e.g. for cell A1 goto 'Data - Validation'
and enter the formula
=EXACT(A1,UPPER(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Colin James wrote:
Does anyone know of a way that I can force cell entries to be
uppercase?