View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default TRUE: Would like it to appear as "True" in the cell.

Either:
format the cell to Text prior to entry
or:
precede the value with an apostophe (single quote)
--
Gary''s Student - gsnu201001


"Lindsay" wrote:

Using Microsoft Excel 2007.

I am typing in a name 'True', but when I type the name it is capitalizing
the entire word 'TRUE'. I would like to capitalize only the first letter in
the name.

How do I achieve this using Excel? I believe Excel recognizes it as a formula.