On a summary worksheet in a report, I'm linking a total to a cell on another
worksheet. Once that number appears in the summary worksheet, I want it
to
be a number and not a reference to the other worksheet

If that is REALLY what you want:
1) copy the cell
2) use Edit | Paste Special and check the Value box

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email