Another approach is to use =FORMAT(A4,"0000000") which creates a string with
the correct number of leading zeros, rather than just displaying it in this
way.

Regards,
David Jessop

"Chip Pearson" wrote:

Use a custom number format of 000000 or as many zero as you need.



"Shadyhosta" wrote in
message
...
I often deal with account numbers with leading zeros. When I
place them in a
cell Excel automatically deletes the leading zeros. Is there a
way to format
the cell to hold the zeros?