Hi,
I have a number of forms with a phone number element which has a mask - 99 9999 9999 or 9999 999 999. I need the spaces so Excel recognises this as a text field not an integer so it doesn't strip off the leading zeros. But when someone uses autofill on the phone number the number ends up with a series of underlines and a couple of numbers. e.g. __ ____ _4__. Can anyone suggest a solution to this problem?
I have a number of forms with a phone number element which has a mask - 99 9999 9999 or 9999 999 999. I need the spaces so Excel recognises this as a text field not an integer so it doesn't strip off the leading zeros. But when someone uses autofill on the phone number the number ends up with a series of underlines and a couple of numbers. e.g. __ ____ _4__. Can anyone suggest a solution to this problem?
Pretty much just "don't use the input mask". And you don't need the spaces at all, just tell excel that the column should be formatted as text.
Sadly, Excel removes the leading zeroes as soon as you open the csv file.
I've tried putting a note in the form to say include zeroes but people rarely take any notice.
Chris A
I've tried putting a note in the form to say include zeroes but people rarely take any notice.
Chris A
https://stackoverflow.com/questions/24612302/excel-is-stripping-leading-0s-from-csv-files/24612774
If they open it in the wizard they can select the column as text.
Or you could try when you're exporting your data to CSV, save the field as
If they open it in the wizard they can select the column as text.
Or you could try when you're exporting your data to CSV, save the field as
=0012401589What exactly are you doing with these CSV files anyway?
I'm exporting the database using the Backup Table button so there's no option of adding an = before exporting. The output is then used to update a membership list so there are lots of iterations as membership renewals arrive.
Looks like the import wizard is the best choice.
Looks like the import wizard is the best choice.
This topic is locked and no more replies can be posted.
