I think you multiplied by 1060, when you should have multiplied
by 1.06 or 106%. And in Tools  Options  Edit, uncheck the box
for "Fixed decimal places".
Leanne wrote:
Thanks for that Garfield. I have done that and it has worked, but now it
wont put the numbers that should be a WHOLE number.
EG  I WANT the decimal point as 1.0759  BUT it is only showing 1075.9.
I have played around with the decimal points in the tools, options menu.
Thanks
"garfieldnodie" wrote:
Multiply by 106%.
Leanne wrote:
I want to add on 6% to each cell. Ranges are from B11  L61. I have put a 6
in a cell by it self, highlighted, paste special, then multiply.
My problem is  it only displays how much 6% is of the sum that I have put
into the cell.
E.G In one cell, I have .58900  I multiply that by 6.0% and get .035340.
Which is correct. BUT I need .58900 + 0.03534 to SHOW that .58900+0.03534 =
0.62434.
How do I do this???
Leanne
