View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Long # turns into a formula-How do I turn that off?

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