Hi folks,
Ive just noticed that when you turn on the collect Emergency Contact details and a client adds their contact name, phone etc - something happens when you export to Excel.  Ive noticed the same on previous events but put it down to my clumsiness.

With the Main contact info, Cell Phone numbers end up formatted  so that it always displays in the Excel sheet as a number and the way it is entered.  In the Excel data bar it displays as a ="12345678" type data and in the cell it displays as entered ie 12345678 
eg extract of Excel Sheet:

EmergencyContactName	EmergencyContactPhone
Joe Blog	12345
Micky Mouse	4.47877E+11
My Test	12345678
The Phamtom	123456789

But in the Excel data for the emergency phone UNLESS you format that column in the exported report  to be "Number" then the phone number is displayed (for me) as a stupid number eg 4.47877E+11 in the cell but is correct in the data bar.
Am I missing something here or doing something wrong. This is just a straight export from a Custom report with selected fields. Surely all phone/cell numbers get formatted the same way - or??
Help please.
Regards

It does happen to me too. I think it has something to do with how the numbers were entered as well so what I do before entering numbers in is that I format the cells as Text instead of numbers. This way, the information entered is treated as text even when there is a number in the cell, the information is displayed exactly as it is entered.

That's what I do too.
It must be a really strange glitch in Excel.

---

Provillus

I had exactly the same problem and the solution mentioned above also resolve my problem.

---

Provillus wartrol

hi guys

HOw are you? I would like to thanks for great information to us. I have seen it than I think that part of the service, your problem is with your healthcare provider and the ... phone system because of the out-of-box default method of logging in from a phone. of internet access and staying in contact through out your journey is a plus but ... might seem strange for a car manufacturer to make phones, but in fact

Thanks

Kaderkhan













 Choix plantes et fleurs

HI

The RegOnline Forums are a great resource for event planners of all types to learn about the company's software and services

Thanks

spa portable - lombricompost

Wearing earplugs can be a bit uncomfortable for some. To help with this issue we offer a range of high quality custom fit ear plugs. These ear plugs are made by casting a mold of your ear formation. Once this has been done a set of custom ear plugs will be created from the mold.
http://www.comfyearplugs.com

---

custom ear plugs