View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gramps gramps is offline
external usenet poster
 
Posts: 46
Default Upper case data entry

I work a 4 week rota which entails 4 different duties, any 5 days from seven.
At the end of that time I produce a duty statement detailing which duty
numbers were worked on what days. The duty number is in the form of 'AB1'.
How can I ensure that even if I enter the duty number as 'ab1' it will be
automatically be entered in upper case format.
Many thanx
--
Al