John T via OfficeKB.com wrote:
Yes, I did that. The problem is that when I do a "Replace" (but not when I
type in a new value), Excel undoes that and reformats it as date. I think it
must be a bug in the "Replace" function, and I'm wondering if there's a
workaround other than preceding every entry with a single quote.

John

Bill Martin wrote:

Try formatting the column of cells as text *before* entering the data...

Bill
-------------------

Not that I'm aware of. One solution would be to write a macro that corrects the
error after the fact. After doing all your Replaces you'd hit a button to
automatically find any entries in the wrong format and correct them back again.

It's an inelegant solution, but it is a solution...

Better yet, write your own custom "Replace" macro that works properly. And add
whatever tweaks make it even better for your own particular problem. I agree
this should not be necessary in an ideal world, but IMHO it's the cleanest solution.

Bill