True, how do I get Excel to ignore?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
How do I get Excel to ignore "a", "an", "the" when sorting? 1
Need to sort part numbers, sometimes ignoring leading letters 8
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to ignore parens in a sort? 3
Formatting in formulas not allowed before commas 5
Disable autoformat of "true" and "false" text 5
Sorting while protected - this question may not have been covered. 1

Back
Top