You're seeing scientific notation format. You could change the format to:

Format/Cells/Number/Custom 000000000000




In article ,
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