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 cavab
  • 0 have this problem
  • 1 view
  • Last reply by JamesJ

more options

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)

more options

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.'
more options

I'm not using any spreadsheet software.

more options

You might try google docs.

more options

You need to elaborate. Use google docs for what?

more options

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.

more options

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.

more options

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

more options

I wouldn't know where to begin with docs.

more options

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

more options

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.

more options

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