7 character cells

[cpdiggler]

I need a column of information to be 7 characters. For example, I have... 587716,
654665, 654666, 1345281.. etc. As you can see I have some with 6 and some with 7. The ones with 6 I need to add a "0" in front of... is this possible?

 

[Aladin Akyurek]

On 2002-05-09 04:29, cpdiggler wrote:
I need a column of information to be 7 characters. For example, I have... 587716,
654665, 654666, 1345281.. etc. As you can see I have some with 6 and some with 7. The ones with 6 I need to add a "0" in front of... is this possible?

In B1 enter:

=RIGHT("0"&A1,7)

where A1 houses the first entry.

Double click on the fill handle of B1 in order to copy it down.

 

[philR]

If you only need it to DISPLAY 7 characters, you can format the cells with a custom format of 0000000
This message was edited by philR on 2002-05-09 05:01