I am outputting data from a datalist in c# to an excel document. One of my
columns contains zip codes, some that are 9 digits, and some that are only 5.
If I use Number Format to format the zip codes like this:

"#####-####"

then the zip codes with only 5 digits show up like this, for example: 1-2345
instead of 12345-

Is there a way that I can tell it to format the number from the left, rather
than from the right?

Thanks!