But if you've "copied the format of that cell", you are copying only the
format, not the formula. Copying formats will not change the underlying
formula in the pasted cell.

We'll be able help you better if you tell us the specific steps you go
through. Start with what's originally in the cells (as shown in the formula
bar), and what steps you follow (eg, Ctrl-C/Ctrl-V or right clickCopy or
drag the fill handle, etc.)

Regards,
Fred.

"shan820" wrote in message
...
I have a worksheet that has cells that work differently in one cell if I
edit
the number (example 21000) in the field to be divided by 7 and multiplied
by
5, it will show the formula as :
=21000/7*5 and then of course show the result in the spreadsheet

I've copied the format of that cell over the other cells, but in other
cells
the same formula results in:
=3000*5

Even in another cell, the result is just the answer to the formula (so the
formula doesn't show up anymore at all ... like i've copy, pasted
values...
but i haven't)
=15000

What is going on with this?

Thanks!