Hi Wondering if there is any easy way of adding some numbers in front
of a whole list of numbers, thanks tim

Tim,

The following formula will put 123 in front of the number in A2. Copy down
with the Fill Handle.

=VALUE(123 & A2)

For a permanent change, copy this column, then over the original column, do
Edit - Paste special - Values. Now you don't need the formula column any
more.

--
Earl Kiosterud
www.smokeylake.com

"Tim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Wondering if there is any easy way of adding some numbers in front
> of a whole list of numbers, thanks tim
>

It could be as simple as say, using putting 1000 in a cell, then copying it
and doing a paste special > add if you want to bump up an entire col of
small numbers by 1000, or it could be something else? which may not be as
simple

For more pointed suggestions, post some sample data (in plain text) of what
you have and what you want done, expected results, etc ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Tim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Wondering if there is any easy way of adding some numbers in front
> of a whole list of numbers, thanks tim
>
>

Thanks for the reply, I can not seem to do this with text though, I would
like to put 2 letters before a number.

ie add nb to a list of numbers

thanks tim
"Earl Kiosterud" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Tim,
>
> The following formula will put 123 in front of the number in A2. Copy
> down with the Fill Handle.
>
> =VALUE(123 & A2)
>
> For a permanent change, copy this column, then over the original column,
> do Edit - Paste special - Values. Now you don't need the formula column
> any more.
>
> --
> Earl Kiosterud
> www.smokeylake.com
>
> "Tim" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi Wondering if there is any easy way of adding some numbers in
>> front of a whole list of numbers, thanks tim
>>
>
>

Hi thanks for the reply
I have a huge list of product numbers and I want to add 2 letters to the
begining of all of them

ie
123
124
125
would like
na123
na124
na125

thanks tim

"Max" <(E-Mail Removed)> wrote in message
news:ONAL8$(E-Mail Removed)...
> It could be as simple as say, using putting 1000 in a cell, then copying
> it
> and doing a paste special > add if you want to bump up an entire col of
> small numbers by 1000, or it could be something else? which may not be as
> simple
>
> For more pointed suggestions, post some sample data (in plain text) of
> what
> you have and what you want done, expected results, etc ..
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Tim" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi Wondering if there is any easy way of adding some numbers in
>> front
>> of a whole list of numbers, thanks tim
>>
>>
>
>

You could give the cells a custom number format of:
"na"General
and still keep those values numeric.
But this just changes what you see--not the values in the cell.

Or you could use a helper cell:

="na"&a1
and drag down.

(convert to values (edit|copy, edit|paste special|values) if you want--and
delete the original range.)


Tim wrote:
>
> Hi thanks for the reply
> I have a huge list of product numbers and I want to add 2 letters to the
> begining of all of them
>
> ie
> 123
> 124
> 125
> would like
> na123
> na124
> na125
>
> thanks tim
>
> "Max" <(E-Mail Removed)> wrote in message
> news:ONAL8$(E-Mail Removed)...
> > It could be as simple as say, using putting 1000 in a cell, then copying
> > it
> > and doing a paste special > add if you want to bump up an entire col of
> > small numbers by 1000, or it could be something else? which may not be as
> > simple
> >
> > For more pointed suggestions, post some sample data (in plain text) of
> > what
> > you have and what you want done, expected results, etc ..
> > --
> > Rgds
> > Max
> > xl 97
> > ---
> > GMT+8, 1° 22' N 103° 45' E
> > xdemechanik <at>yahoo<dot>com
> > ----
> > "Tim" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> Hi Wondering if there is any easy way of adding some numbers in
> >> front
> >> of a whole list of numbers, thanks tim
> >>
> >>
> >
> >

--

Dave Peterson