Hi,
you can have that number in one cell let's say A1 and then you want to
multiply everything in column B by that number

=B1*$A$1

copy formula down

"KTK" wrote:

I need to multiply the content of a cell by a number (e.g. 2) but have been
receiving the error message saying that there is a circular reference. Is
there a way out?