We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

Tìm kiếm hỗ trợ

Tránh các lừa đảo về hỗ trợ. Chúng tôi sẽ không bao giờ yêu cầu bạn gọi hoặc nhắn tin đến số điện thoại hoặc chia sẻ thông tin cá nhân. Vui lòng báo cáo hoạt động đáng ngờ bằng cách sử dụng tùy chọn "Báo cáo lạm dụng".

Tìm hiểu thêm

Thunderbird Address Book

  • 11 trả lời
  • 0 gặp vấn đề này
  • 1 lượt xem
  • Trả lời mới nhất được viết bởi 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

Tất cả các câu trả lời (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.