Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
wrong result when using sum() toghether with tracking changes
In word table I use fields Formula to sum the values in the column.
When the track changes is actived, any change in column cells shows both values (the new and old). waiting until the is accepted or rejected In This scenario a field update in the last cell in the column with the =sum() Formula show a wrong result. The cells with changes shows the new number and old number. The sum() function takes the entire digits of both number to calculate the reult. How the right result can be shown as a change tracked and not the wrong result? I am using a word 2000. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
wrong result when using sum() toghether with tracking changes
Hi Daniel,
There is no reliable way to do this without using a macro to do the calculation, assessing whether each value has been deleted via Track Changes. Cheers "Daniel" wrote in message ... In word table I use fields Formula to sum the values in the column. When the track changes is actived, any change in column cells shows both values (the new and old). waiting until the is accepted or rejected In This scenario a field update in the last cell in the column with the =sum() Formula show a wrong result. The cells with changes shows the new number and old number. The sum() function takes the entire digits of both number to calculate the reult. How the right result can be shown as a change tracked and not the wrong result? I am using a word 2000. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Field Formatting | Mailmerge | |||
CardText Field Switch | Mailmerge | |||
Method for displaying dollar amount as written on bank check | Microsoft Word Help | |||
How do I turn dollar amounts into words? | New Users | |||
Garbage at end of document | Microsoft Word Help |