T.R. Valentine When you open a tab delimited file in Excel it automatically recognizes the data types. Therefore your string e.g. 2011-02-26 10:23:47 is correctly interpreted as a value. Therefore it is natural that using FIND, VALUE, LEFT or any other functions would not work.
As I said in the previous post you need to use other functions. LibO and OOo don't have any problem with tab delimited files. The only difference is that you can not Open a tab delimited file (otherwise it is loaded in Writer). You need to Insert, Sheet from File. Luuk Indeed there is a lot of work... I just found another bug: typing =now() in a cell shows the value instead of a date (of course you can format it yourself...) -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2581181.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
