Would like to know how to display phone number format in column. Upon excel file import, the imported data for phone number column displays correctly. When saving, the phone number column changes to some unknown format. The number values actually change.
On the attached screenshot, the phone number data was originally 6614065812. The +1 is a prefic
Yes you get different number because you use integer column type and there is php intiger limitation that you can use numbers. The size of an integer is platform-dependent, although a maximum value of about two billion is the usual value.
My suggestion is to change column type to string and you will get results that you need.
Would like to know how to display phone number format in column. Upon excel file import, the imported data for phone number column displays correctly. When saving, the phone number column changes to some unknown format. The number values actually change.
On the attached screenshot, the phone number data was originally 6614065812. The +1 is a prefic
Hi Francisco,
Thank you for your purchase.
Yes you get different number because you use integer column type and there is php intiger limitation that you can use numbers. The size of an integer is platform-dependent, although a maximum value of about two billion is the usual value.
My suggestion is to change column type to string and you will get results that you need.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables