Make sure in your spreadsheet that this column (and others like it) are text format, you should see this below. In later versions of ITSM, macros are provided with the spreadsheets to automatically fix the formatting
[cid:[email protected]] ________________________________ Ross Mitcham Lead Product Developer Direct +1 905.707.3534 50 Minthorn Bvld. Suite 200 Markham, ON L3T 7X8 Canada [BMC Communities]<https://communities.bmc.com/> [Twitter]<https://twitter.com/bmcsoftware> [Facebook]<https://www.facebook.com/bmcsoftware> [YouTube]<http://www.youtube.com/user/BMCSoftwareBMCtv> [LinkedIn]<http://www.linkedin.com/company/bmc-software> [Communities]<https://plus.google.com/+bmcsoftware/> [BMC Software|Bring IT to Life]<http://www.bmc.com/> From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Shafqat Ayaz Sent: Tuesday, June 16, 2015 2:08 PM To: [email protected] Subject: Re: Data Management Job Another Problem ** Hi All Another issue coming up. While loading People data using BMC templates the telephone number is being imported as a decimal value, for example a phone number of 01913558976 is showing up as 01913558976.0 Any help would be appreciated. Shafqat Ayaz _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
