Tag Archives: Excel

Pseudo-Scientific Notation, or The Mysterious Case of the Middle E

Typing a part number like 32E50 into an Excel spreadsheet can give you fits.  Excel thinks you are using shorthand for scientific notation, and converts this string into the number 3.20E+51 (or 32 with 50 zeroes) – Ugh!  The way to overcome … Continue reading

Posted in Everybody, formulas, Lit Support | Tagged , , , , , | 1 Comment

Finding and Reviewing Comment Boxes in Excel Files

Following the Wells Fargo inadvertent disclosure episode, I wrote a blog post describing several ways to find hidden content in Excel files.  In this post I discuss another feature of Excel that all lawyers, but especially legal document reviewers, should know about: the comment box. … Continue reading

Posted in CLE, eDiscovery, Lit Support, Native File Review | Tagged , , , , , , | 2 Comments

Nassau County Bar Association CLE Event – March 8

The Nassau Academy of Law, the educational arm of the NCBA, will host an Excel Esquire CLE lunch program called “Excel Essentials for the Practice of Law” on Wednesday, March 8.  Lunch is served at 12:30, and the one-hour program … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas | Tagged , , | Leave a comment

Find & Redact Social Security Numbers in Excel Files

A raft of state and federal laws require the redaction of social security numbers from publicly available documents.  For attorneys, this usually means that documents produced in litigation must be scrubbed of SSN’s.   In my experience, many parties resort to … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Native File Review | Tagged , , , , , , , | Leave a comment