View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How do I stop Excel from changing the word true to TRUE?

Try this:
Either put an apostrophe before the name: 'True
Or
FormatCellsNumber
Category: TEXT


Does that help?

***********
Regards,
Ron


"Schmyerlou" wrote:

I am typing names and addresses into an Excel spreadsheet. I have one person
whose first name is True. When I type it into the cell, it converts it to
TRUE. I know this is a function/formula, but how do I stop it from doing
that?