True, how do I get Excel to ignore?

G

Guest

Subject name is True but Excel makes it TRUE and will not sort etc. How do I
get Excel to ignore this. Now I have a space before the name and it keeps it
lowercase but will not sort correctly.
Thanks
 
N

Niek Otten

Precede True with an apostrophe. It will not show and sort correctly

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Subject name is True but Excel makes it TRUE and will not sort etc. How do I
| get Excel to ignore this. Now I have a space before the name and it keeps it
| lowercase but will not sort correctly.
| Thanks
 

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
Font Case in Excel-HELP!!!! 6
Disable autoformat of "true" and "false" text 5
Very Simple formatting Question 4
How to STOP Excel from changing my data 1
I want to sort on titles but wish to ignore, but not delete, the . 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Doesn't Open 10

Top