Hi there!

I've got a survey with a question, where you should write a kind of ID of 9 numbers. The ID could start with 0. When you export it in xls, it automatically cuts off the 0-s from the beginning. It's quite a problem when you want to work with the data.

I've tried it with numbers and short free text with and without /^([0-9]{9})$/ validation, but no success at export. (2.06+ Build 151018)

Any idea?

Thanks in advance!

Br,
Thomas

Found a workaround:
/^([0-9]{3} [0-9]{3} [0-9]{3})$/ works fine. (in "000 000 000" format instead of "000000000")

But I'm still interested, if I could use it without any workaround.

The problem is excel I guess, because with short free text it should work. Have you tried to export via CSV and checked what is written there. I would guess the "0" is still there.

But Excel usually cuts of trailing zeros.