Leading zeros with text

G

Guest

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
 
G

Guest

If it's just a matter of formatting to look that way, go to cells, format,
number, custom, '0000000000000'
 

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

Leading zeros with text 1
Add Leading Zeros 4
Leading Zeros 2
how to create leading zeros on variable length numbers 4
Adding recognised Zeros 5
decimal places and leading zeros 2
Excel Leading Zeros 3
Leading Zeros 9

Top