Hi Roni wrote:

If in sheet1 the number is 10, in sheet2 it will be 00000010 (text
format).
How can I change the format in sheet1 to 8 character text like the
format I have in sheet2?

=text(a1, "00000000")

arno