I have done that too, and the same thing happens. I save the file. Close it
out, and when I reopen it, the formula is back.

"Bob I" wrote:

Put single quote first when you enter it as in
'200704301524


Chris wrote:

I have to enter the date in a certain way, yyyymmddhhmm.
I enter 200704301524 into a cell. I save the file in .csv. When I open the
file again, the # is changed to a formula, 2.00704E+11
How do I get it to not do that? I have tried saving it as a text, and it
still doesn't work.
Thanks,
Chris