Precede your data with an apostrophe (').

For example:

'-000123

HTH
Jason
Atlanta, GA

-----Original Message-----
If I put a dash and put zeros in after it, how can I
make it stay in that
format? Or even, how can I make a cell display multiple
zeros instead of
one? I have custom formatted a cell but it doesn't hold
it's properties when
it comes to combining cells. Thanks.
.