View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default My Formula Changes on it's own?

Took a look at your file, Earl, but I couldn't see anything wrong with it.
Note that I'm using only Excel 97 here, so I won't know about / "experience"
the new features found in the later versions, such as the steps mentioned in
RD's views. For eg: I don't have this option: "Extend List Formats And
Formulas" under: Tools Options Edit tab.

The copy paste special values part also worked ok,
based on my testing here on your sample file. There were no discrepancies in
the values pasted from the formula cells (tested a couple).

Think that's about all I have further for you.
Perhaps others may step in with their diagnosis / views ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"EARL" wrote in message
...
http://flypicture.com/file/?id=rtn2k63c

1/5/06
Max: The above link is the location of the spreadsheet that we are having
trouble with the cell problems. We have high-lighted the problem cells.
When working with the spreadsheet this week-end, there seemingly were
additional cells that began changing in copy/paste mode. When pasting to

the
next month's spreadsheet, we paste special as 'values' which one would

think
would bring them over as EXACT numbers. However, one cell pasted .02

cents
short of the copied amount, and the other cell pasted .11 cents short of

the
copied amount.
This is really mind-boggling!!!
Thanks for your help on the procedure to generate a link. Hopefully you
will be able to pull the worksheet up and help figure this out.

Also, thanks to Max and Ragdyer for your interest and assistance up until

now.
Hope to hear from you soon on your ideas.

EARL