I'm using the track changes availability on Shared workbooks to act as an audit trail. I have it "print to a new sheet" I have some questions....

1. The date and time comes out non-formatted (i.e. 10/24/2006 comes out as 39014). Is there a way for this to come out properly? I have been copying and pasting to a fresh sheet to reformat since the original sheet is locked.

2. I have a similar problem with # of digits. The Track changes on the separate sheet is telling me I changed value from 0.0 to 0.0 rather than 0.0012 to 0021.

3. Is there someplace where I can find out more about this function? I'd like to see the possible "Action types" or "Changes". The Help Function on this one is very sparse.

Thanks!
ChemistB