7 character cells

cpdiggler · May 9th, 2002, 05:29 AM

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 · May 9th, 2002, 05:35 AM

Quote:

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 · May 9th, 2002, 06:00 AM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 05:29 AM	#1
cpdiggler New Member Join Date: Apr 2002 Posts: 6	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?

May 9th, 2002, 06:00 AM	#3
philR Board Regular Join Date: Feb 2002 Location: Sheffield, UK Posts: 249	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 ]