View original (French)

OpenOffice Calc zero or more is erased

Solved
martouf Posted messages 45 Status Member -  
transat Posted messages 31956 Registration date   Status Contributor Last intervention   -
Hello,
I have a problem with OpenOffice Calc where the zero or plus sign (0 or +) gets erased:
I use OpenOffice Calc to create and modify my Contacts directory (First Name, Last Name, Display As, Email 1, Mobile 1, Tel 1, Email 2, (...))
For phone numbers, both mobile and landline, I need to keep a zero or a plus as the first character of my cell to be able to import the directory onto my mobile. However, when I enter a number starting with a zero (for example, 06...) or a plus (for example, +33...), it disappears automatically when I leave the cell.

Can someone help me?
Thanks in advance.

Configuration: Windows XP / Firefox 3.6.3

2 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello

    You have several options, but the simplest one is probably to enter an apostrophe as the first character, and then you can enter plus signs or zeros without any problem.
    --

    Always zen
    1
    1. martouf Posted messages 45 Status Member 18
       
      Alright, I had thought about it, but the problem is that if I want to use the file for my mobile phone, I only need the digits of my contact's phone number!
      With the apostrophe, it's impossible to use this file on my phone.
      Thanks anyway, and if you have other methods...
      0
  2. transat Posted messages 31956 Registration date   Status Contributor Last intervention   9 021
     
    Hello
    http://ioj.com/v/wp7ga
    @+
    --

    Curiosity on CCM is not a flaw but an asset.
    0
    1. martouf Posted messages 45 Status Member 18
       
      Thank you
      0
    2. transat Posted messages 31956 Registration date   Status Contributor Last intervention   9 021
       
      You're welcome
      See you later
      0
    3. martouf Posted messages 45 Status Member 18
       
      And for the default formatting, how do we ensure it is in Text and not in Serial_Number?
      0
    4. transat Posted messages 31956 Registration date   Status Contributor Last intervention   9 021
       
      Re
      http://ioj.com/v/wzmar
      0
    5. martouf Posted messages 45 Status Member 18
       
      No, I need the default one because when I reopen the file, the zeros disappear!
      0