Problem with Word table in Excel

[Arsenio Oloroso]

Hope someone can help. Here's my problem.

I want to easily double the amounts in each row of a column in a
Microsoft Word table. I exported the table to Excel, inserted a column
(column B) next to the one I wanted to work with, and typed the formula
=A1*2. I then copied it to the rest of the cells in the B column.

Of course, it worked. All the numbers in the A column were doubled in
the corresponding B-column cells. But when I went to copy the doubled
B-column numbers into the A column, I got a circular reference error.

Problem is that I'm copying the formula, not the actual numbers. I also
tried converting the values in column B into text, using Excel's text
function. But I got the same result. Again, I'm copying the formula,
not the text-formatted numbers.

How do I work around this? My objective is to export the revised table
back to Word from Excel.

Any leads are much appreciated.

Arsenio

 

[duane]

did you try copying col b and pasting in col a as values

 

[Arsenio Oloroso]

yeah. Same thing. I get an "invalid cell reference" error message when I
move the b-column formula =a1*2 into the a column.

 

[duane]

copy and paste special as values. sounds like you copied the formula

 

[Ragdyer]

After you have your column B populated with all the formulas, and it's
displaying all the correct calculated data, do this:

Select *all* the cells in column B that you wish to convert.
Right click in this selection.
Choose "Copy".
Right click *again*, and choose "PasteSpecial".
Click on "Values", then <OK>, then <Esc>.

You should now have *only* numbers in column B.

 

[Arsenio Oloroso]

Thanks, I'll try that.

 

[Arsenio Oloroso]

Sounds like a plan. I'll try it. Thanks much.