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

G

Guest

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

Guest

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


Does that help?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRUE: Would like it to appear as "True" in the cell. 2
True to TRUE 3
Excel How to get output of the formula instead of True or false 1
Stop URLs from changing font size - Excel 2007 2
How to find first row where condition is true? 12
How to STOP Excel from changing my data 1
True, how do I get Excel to ignore? 2
Add word in cell changes to word TRUE 3

Top