hello Gord,
thank you you were right about that,now i have anouther question,ok now i
have a exel sheet with in one column all the way down 1000 different letters
like , abt2mm,hgt3nn,jhl700 and so on now i'd like to add .jpg on the end of
all these letters to look like, abt2mm.jpg,hgt3nn.jpg and so on can you help
me to do this, i know its a formula like A1= something but i can remember.

help please

"Gord Dibben" wrote:

I think what you are doing is hitting Enter key when you should be hitting Esc
key.

Follow my instructions to the letter and see what happens.


Gord

On Sat, 16 Sep 2006 06:48:01 -0700, Morefeus Direct
wrote:

thank you for you reply but when i do as you ask it still does'nt work, it
either changes the value to 0 or it multiplies that value by its self.

please help


"Gord Dibben" wrote:

Type 1.25 in an unused cell.

Copy that cell.

Select the column of numbers and EditPaste SpecialMultiplyOKEsc.

Delete the cell with the 1.25


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
wrote:

hello anyone how can help, i'm new to exel ,now in exel i have a column of
different number like 512.00,654.00,68.56, and so on down this colunm and i
want to add say, 25% to all the values in this column, how do i do it?

there are over 1000 different number combinations in this column.

Please help
Morefeus Direct.com