Hi,

I cannot stop the string 'mar1' from formatting as a date.

I tried formatting the cell as text. I tried prefixing it with a single ' .

I was actually trying to import a file from a CSV using the text import. I tried surrounding the field with double quotes.

I tried specifying 'text' as the format of the column in the text input dialog.

Any idea how to stop this? All I want to do is get some text to sort right and dates sort to the top of text. For example, anyone can try entering the following 3 lines:

aaa
bbb
mar1

Then sort it.

Thanks!
Dave