Hi Meinard,
Your problem is that the cells are formatted to display the
date as 10-02-06. Select the cells, then select 'format /
cells'. Choose the 'number' tab, then 'date' and pick the
format string that matches your requirements. If it's not
there, you can create your own custom format string.
tc
You appear not to be subscribed to the users mailing list.
You could miss many of the replies to your post unless you
do subscribe. Just send a blank message addressed to
<[EMAIL PROTECTED]> using the e-mail account
through which you want to receive it. You will receive a
message asking you to confirm your subscription by replying
to it. See http://support.openoffice.org/index.html for more
options.
-----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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
