If i understand you right, you want your numbers a certain amount of digits
long, and if they are not, then add 0's until they are. If that is right you
can use this method
=TEXT(A1,"00000")

select the cell with the number, then put a 0 for the number of digits you
need, the above has 5 so the result of the number 124 would now be 00124.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"CommerceMary" wrote:

I need to keep a fixed field width for a file that I am importing into
another program. The other program will only except a certain format. Each
field needs to have a specific number of characters and if the values are
less than that number we need to right justify and zero fill. Can we have
excel recognize the number values and zero fill, on the front end, if there
are not enough characters?