Does OpenOffice have a calculator imbedded? Roxann Milby Wing B Office Admin
-----Original Message----- From: Meinard Eekhout [mailto:[EMAIL PROTECTED] Sent: Saturday, March 18, 2006 6:47 PM To: [email protected] Subject: Calculator is meddling with my data? Hi, I have a spreadsheet with time-series data which i want to use in Stata. That program does not like 10-02-06, but it needs to be written as 10feb2006. The most easy way to change the dates should be to use the find and replace option. That is where all the problems start. When i try to replace -12- with dec (or -02- with feb) it only highlights the cells of the month, without replacing them! When i select one month and try to replace the month number with the abbreviation (with the selection only option), then it does not find anything at all or does something strange! The only way to replace something is by typing it all by yourself, but even THAT is impossible since it automatically changes back. How can i prevent Open office calculator (or ms office because it has the same problem) to meddle with my data?! Regards, M.Eekhout --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
