please help me !!!!!!!!

[#1]

Dear All,
I need help for this problem.

in customer code field I have a code build by 00 before a number
for example:
001234
Total 6 digits.

Now I have sent to excel and I reloaded the data but the
customerCode lost the
double '00' :
now the code 001234 is 1234 and so it doesn't link a customer name.

please note the customer loaded from database works but the customer from wxcel doesn't work correctly.
the customer is formed by 2 rows:

CustomerCode | Customer name
001234 | AAA
1234 -

How fix it . Please I have a Budget pending 😞

thanks

Best Regards,
Slash

[hector]

hi, have you tried text() function? or in your case maybe the num function will work too. If you use num, use this way num(field,'000000')

rgds

[#3]

Hi,

see the example (script) and function Num.

Good luck!

Rainer