Length of field

[coolwaters]

Hi,

A column in excel has ID field with numbers. Some begin with 0's.

I am able to get the data into QlikView with the 0's which is correct. But i also need to know the length of the field and the 0's are getting ignored when using LEN(). I need the length considering the 0's which should be 11 for all the ID's.

I have tried using Text() but strangely it is trimming the 0's.

Thanks.

[coolwaters]

Hi Antonio,

Works, thanks again for all your help.