What? Can you be more specific? Post the formula and an example of the cells
contents.

"greg" wrote:

when i copy a formula to another cell it does it correctly, but it also shows
the same value from the copied cell.