The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer. All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. This policy is subject to change at any time. The owner is not an attorney, and nothing posted on this site should be construed as legal advice. Litigation Support Tip of the Night does not provide confirmation that any e-discovery technique or conduct is compliant with legal, regulatory, contractual or ethical requirements.
Featured on the ACEDS blog.
Follow me on Twitter and see How-To Videos on my YouTube channel.
New tips for paralegals and litigation support profesionals are posted to this site each night. Click on the blog headings for better detail.
A common problem in Excel is the need to convert numbers stored as text in a column to the number format. Numbers stored as text may not give correct results when they are referenced in formulas, and they will not necessarily sort in order with other numbers in the same column that are correctly formatted [although Excel should prompt you to sort them as numbers].
If you have a very long list of numbers, it may take a lot of scrolling back and forth to find where numbers stored as text begin in a column. If you find the first instance of numbers stored as text in a column, you can select from that cell to the end of the column, and click, 'Convert to Number'in the drop down menu on the right. All of the numbers in the column will be correctly formatted.
However in a column with thousands of numbers it may be hard to find the first instance of a cell with numbers stored as text. Use the ISTEXT formula in an adjacent column to identify which numbers are being read by Excel as text.
The formula will give the result "TRUE" for cells that are in the text format .