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

" 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.