Leading zeros with text

G

ginzbeez

Hi,

I need help on specifying the maximum length of characters contained in a
cell. Additionally, once the length is specified, I need the data contained
in the cell to fill the maximum allowable characters for the cell with
leading zeros (if the data does not satisfy the maximum length).

i.e. If I have a name such as 'gray' in a cell and the cell is only allowed
to be 13 characters long, how do I get a return of 000000000gray
 

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

Similar Threads


Top