I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS
I JUST WANT TO INSERT A LETTER PREFIX IN FRONT OF
NUMBERS BUT WITHOUT CHANGING THE LETTER I WANT TO INCREASE THE VALUE FOR
EXAMPLE
EH001
EH002
EH003
EH004
LIKE THIS HOW CAN I SOLVE IT

Type: EH001
and copy down as far as needed


"Nathan" wrote:

I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS
I JUST WANT TO INSERT A LETTER PREFIX IN FRONT OF
NUMBERS BUT WITHOUT CHANGING THE LETTER I WANT TO INCREASE THE VALUE FOR
EXAMPLE
EH001
EH002
EH003
EH004
LIKE THIS HOW CAN I SOLVE IT

In your first cell EH001 and drag down, to be honest if you take your
Caps lock off and give us more information we could help you more.

Nathan;490198 Wrote:
I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS
I JUST WANT TO INSERT A LETTER PREFIX IN FRONT OF
NUMBERS BUT WITHOUT CHANGING THE LETTER I WANT TO INCREASE THE VALUE
FOR
EXAMPLE
EH001
EH002
EH003
EH004
LIKE THIS HOW CAN I SOLVE IT


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=135133

I think copy will not work. Instead of copy you have to drag it for the
remaining cells by using mouse, Otherwise select the EH001 cell and extend
the selection upto which cell you want it to fill the continuous series then
select EDITFILLSERIESTYPEAUTOFILL. Then give ok.

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Teethless mama" wrote:

Type: EH001
and copy down as far as needed


"Nathan" wrote:

I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS
I JUST WANT TO INSERT A LETTER PREFIX IN FRONT OF
NUMBERS BUT WITHOUT CHANGING THE LETTER I WANT TO INCREASE THE VALUE FOR
EXAMPLE
EH001
EH002
EH003
EH004
LIKE THIS HOW CAN I SOLVE IT

..
Dear Sir/Mam
I Want to insert a letter in front of a numbers
but I want to increase the numbers with out changes in letters
For
EXAMPLE
eh001
eh002
eh003
eh004
..
..
..
..
..
..
..eh999
How can i Solve it

Teethless mama has already given you a way to do this, but perhaps you are
not familiar enough with Excel to implement it. Try this. Put EH001 in a
cell... select that cell... see the small black square in the lower right
corner of the the (selected) cell?... click on it with the left mouse button
and, while the mouse button is still depressed, drag it down several rows,
then release the mouse button. See... you have the series of values you
asked for. You can click drag the small black square down as far as you
like.

--
Rick (MVP - Excel)


"Nathan" wrote in message
...
.
Dear Sir/Mam
I Want to insert a letter in front of a numbers
but I want to increase the numbers with out changes in letters
For
EXAMPLE
eh001
eh002
eh003
eh004
.
.
.
.
.
.
.eh999
How can i Solve it

Easiest way is what Teethless Mama and Rick has mentioned. If you are looking
for a formula; try the below

="eh" & TEXT(ROW(A1),"000")

If this post helps click Yes
---------------
Jacob Skaria


"Nathan" wrote:

..
Dear Sir/Mam
I Want to insert a letter in front of a numbers
but I want to increase the numbers with out changes in letters
For
EXAMPLE
eh001
eh002
eh003
eh004
..
..
..
..
..
..
..eh999
How can i Solve it