"Dotan Cohen" <[email protected]> wrote in message news:[email protected] > A new OOo user is using Calc to store information on volunteers in an > organization. Israeli ID numbers are 9 digits in length, such as this: > 317907977 > > However, Calc has reformated them to this: > 317908000 > > This is a major dataloss for the organization. The person in charge is > pissed, and both myself and OOo are to blame. OOo is already coming > off their machines (14 desktops, and I think a few laptops as well) > and I am tasked with recovering the missing data. Is this possible?
>From the Peanut Gallery: Have you checked to see that a user-defined cell format hasn't been created? Where you set the format to text, number, etc., take a look at the user-defined and see if something has been created there. In Excel, there is something called an auto-open macro. Any chance there is such a thing in OO.o? Long shots I know, and I can shoot them down easily myself, but ... I'd still check them if it were me. I can't find anything else related to rounding of numbers. HTH, Twayne` --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
