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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Veronica" wrote in message ...
| 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