Thought I'd share an interesting experience. I've been trying to use Office 2007 at my new job. (It is a bit of a struggle. I'd rather use Office 2003.)
I imported a tab-delimited file into Excel without a problem. One of the fields was in MM/DD/YYYY HH:MM tt format. I wanted to divide the one field into a YYYY-MM-DD field and an H:MM field. Excel could NOT do it. It could separate the fields, but Excel *insisted* they had to be text fields (with the apostrophe mark in front). Neither the VALUE nor the DATEVALUE fields worked. After several minutes of being stymied, I installed LO and launched Calc. The same formulas that didn't work in Excel, worked in Calc just as I wanted. So score one for Calc being able to do the job when Excel failed miserably. -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- 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 ***
