Numeri con 000

[sergran]

Hello everybody, I've imported from Excell a database containing numbers anteceduti from the "0" (0001 .. 0002 etc etc) but when I go to copy the column in a table in a text field, I copied only the digit after the "0".
How can I do to add the "0" so that the total of the digits is always 4?


thanks

[JoeM]

If you view the table that you first imported the value into, does it contain 4 characters?
If so, and it it being lost when copying, how exactly are you copying that field over?
Note that you can use the FORMAT function on numeric fields to insert leading zeroes, i.e.

FORMAT([FieldName],"0000")