ExcelBanter - Copied Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copied Cell (https://www.excelbanter.com/excel-discussion-misc-queries/98151-copied-cell.html)

Jasim Al-Ajmi

Copied Cell

After copying a fomula in excel, I ended up with the proper formula, however,
it copied the value of the cell from which I have copied the fomula.

When I tried to create the formula instead of copying it, I ended up with
zaro.

Gord Dibben

Copied Cell

ToolsOptionsCalculation in "Manual" mode?

Change to Automatic.

Post the formula and show us what is in the referenced cells.

Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 14:54:02 -0700, Jasim Al-Ajmi
wrote:

After copying a fomula in excel, I ended up with the proper formula, however,
it copied the value of the cell from which I have copied the fomula.

When I tried to create the formula instead of copying it, I ended up with
zaro.

All times are GMT +1. The time now is 02:41 AM.