Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Thunderbird Address Book

  • 11 பதிலளிப்புகள்
  • 0 இந்த பிரச்னைகள் உள்ளது
  • 1 view
  • Last reply by JamesJ

I imported a google contacts export csv. Problem is the phone numbers format have no dashes between the different parts of the number. I want to import them and use a "-".

Any way to accomplish this?

James

I imported a google contacts export csv. Problem is the phone numbers format have no dashes between the different parts of the number. I want to import them and use a "-". Any way to accomplish this? James

All Replies (11)

Yes, If you use Excel or similar spreadsheet, this macro should do it:

 =replace(replace(XX,4,0,"-"),8,0,"-")   where XX represents the cell of the topmost phone number. The format assumes three digits for area-code followed by seven-digit number.  Then, highlight and drag down the rest of the column. If you have another spreadsheet, there is likely a similar macro to 'replace.'

I'm not using any spreadsheet software.

You might try google docs.

You need to elaborate. Use google docs for what?

I decided to export and import again after deleting the old list. After importing the phone format was ok: 123-456-7890

But, after closing thunderbird and opening it, Thunderbird remove the format: 1234567890

Don't know why Thunderbird would change this.

I found that thunderbird wasn't changing the phone number formats. Two-thirds of the phone numbers have no separators: (1234567890). I have no idea how they got that way. Now I'm trying to figure out how to fix this.

My thought was that Google Docs has a spreadsheet that might do the correction for you.

I wouldn't know where to begin with docs.

I'm getting no assistance at Google help!! I really have no clue who to ask about this!!

Well, it's not really a Thunderbird issue, so I gave a suggestion on how to fix it. But do you need the dashes? I believe Thunderbird will still store the numbers for you.

The numbers are easier for me to read. And yes, thunderbird still stores the numbers.