Hi,

If the data is in Column A, use this formula in Column B(assuming that the
maximum width is 4 characters)
=REPT(0,4-LEN(A1)) & A1

Alok

"Daniell" wrote in message
...
I have a field that can be three for four character. The problem is when
I
sort the column it does not sort correct. What I need is to place a 0 in
the
field that has three digits in it. Is there a funtion that check for the
number of digits and places a zero in the fileds that are to small?


Thanks in advance for the help,