Sorry for the confusion - yes, putting =A1/1000 into cell A1 will result in a
circular reference error. That formula would have to go into a different
cell on the sheet. Thanks to Dav for clarifying.

If you want to permanently change the original value, it takes a couple of
steps. Assume your numbers are in column A. Then in column B write the
formula to divide the value next to it on a row by 1000. That is, in B1 you
would have =A1/1000 and in B2 you would have =A2/1000. You don't have to
manually enter all of the formulas, you can enter it once and use a couple of
different methods to 'extend' or fill the formula down the sheet as far as
you need to go with it. Use Excel Help and search for 'Fill data in
worksheet cells' to find out how to do this.

Once you've done that you can select the cells in column B and use Copy,
then go back to column A and use the Edit | Paste Special command and choose
the [Values] option in that dialog box to replace the original values in
column A with their /1000 value. Then delete the stuff in column B.

"Ron" wrote:

Thank you, but when I put this in the formula, it states that it is a
circular formula.

"JLatham" wrote:

In the cell where you want the division to occur enter a formula similar to
this:
=A1/1000
This assumes that the value you want to divide is in cell A1.

"Ron" wrote:

I would like to take a cell and divide it by 1000. What is the proper way to
do this?