concatenate & custom formats

J

Jeff Davis

I have a cell with a custom format of 0000 so that a 1 will return 0001 in
the cell. I am trying to use the concatenate function to combine multiply
cells into one. When I do this I lose the zero place holders, how can I
retain my format?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top