One way:
=REPT(0,6-LEN(A1)) & A1

HTH,
Paul

"Carrie" wrote in message
...
I have a spreadsheet that has numerical values in cells of different
lengths,
ie xxx, xxxxxx, etc. I need to make all the values 6 characters long by
adding or removing zeros at the beginning and therefore not altering the
value. I then want it to appear as text rather than number. Can anyone
help