hello Joe,
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


" wrote:

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?

Two possible ways, depending on what outcome you want.

1. If you want the +25% value in another column, then if the original
numbers are in A1:A1000, put the following formula into B1 and copy
down through B1000:

=A1*1.25

2. If you want the original numbers to be overwritten with their value
+25%, put 1.25 into some cell (say B1), then right-click B1 and select
Copy, then highlight A1:A1000, right-click and select Paste Special,
then select Multiply. You can delete the value in B1, if you like.