View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roz
 
Posts: n/a
Default imported text data converting to dates


I don't know if this will work, but the cells that are automatically
converting, try to look up the format of these cells. Higllight them,
right click, and click format cells. Under the number tab, you will
find all sorts of ways to format that cell to look any way you want.
If you just want it to be a number, pick general. If you want it to
look like something else, look thru the options and you can program
those cells to look that way. Excel probably somehow was programmed
to put dates in those cells. I had the same problem, I wanted to put
in 1/4 as in a quarter inch, and without me doing anything, excel
changed 1/4 to Jan 4. I did as mentioned above and it fixed it. Hope
it works for you!


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=495224