True, how do I get Excel to ignore?

V

Veronica

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
 
Top