>From: Christian Roth <[EMAIL PROTECTED]> >Sent: Sep 27, 2006 2:36 PM >To: [email protected] >Subject: [users] [de-users] Calc > >Hallo! > >Ich hab folgendes Problem. Und zwar m�chte ich in einer Spalte >z.B. das Zeichen '-' duch das Zeichen '/' ersetzen. > I have a problem. this has do do with the use of a em dash "-" versus the forward slash "/" in within the Calc program.
>Das Problem dabei ist, das es sich dabei um Telefonnummern >handelt, die im Moment in der Form " xxx - xxx" vorliegen. >Sie sollten m�glichst das Format "xxx/xxx" annehmen. My specific problem has to do with telephone numbers and how they are formatted. At the present moment I am using "xxx - xxx" and I wish to change them and use the "xxx/xxx" format. > >Gibt es irgendeine M�glichkeit, dieses zu tun? How can I do this? Christian: First, this is an international mailing list where Englisch is used. However, I think I understand your problem. This is possible, if you change the format of the field from General to Text only. Otherwise, when you input any two numbers with the forward slash in them, OpenOffice.org will treat this as a mathematical calculation and give you the result. Try this and let us know what happens. Tchuess! James McKenzie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
