You can use a formula like =TEXT(A4,"0000") to force padded zeros to show, or
you can make a custom number format like 0000 to make up to 4 leading zeros
show, (but the actual data will not be changed)

Hope that helps,

TK

"dlb1228" wrote:

i have a field that has a number in it for example
100
115
116
12

i want these to always be 4 digits and put zeros in front of the number
how can i do this