How do I stop Excel from changing the word true to TRUE?

S

Schmyerlou

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?
 
R

Ron Coderre

Try this:
Either put an apostrophe before the name: 'True
Or
Format>Cells>Number
Category: TEXT


Does that help?

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