phonebook expoting and importing leading zero's

Discussion in 'General' started by satchid, Jan 23, 2010.

  1. satchid

    Joined:
    Sep 13, 2007
    Messages:
    57
    Likes Received:
    0
    hallo all,

    I made a short test phonebook in Elasix looking like this:
    Manual input:
    049482xxxx test 5569 Delete Edit

    exported in excel it shows no leading zero,

    49482xxxx test 5569
    The leading zero of the tellephone number is lost.

    Of course this is not working when reimported in Elastix.

    Is this a solvable problem, and how should i proseed.

    To refrase the question: how can i avoid Excel deleting the leading zeros?

    Thank you,

    Willy
     
  2. chocho

    Joined:
    Nov 7, 2007
    Messages:
    74
    Likes Received:
    0
    The easy way is to format the cells with 'Text' category.
     
  3. satchid

    Joined:
    Sep 13, 2007
    Messages:
    57
    Likes Received:
    0
    Thank you, inded it works.
    Willy
     

Share This Page