Reports - Number Stored as Text

Reports - Number Stored as Text

Number Stored as Text

Occasionally when working with Reports, a report exported to Excel will display a warning saying "Number Stored as Text".

This article demonstrates a few easy ways to convert the field from Text into a Number. 

Recognizing Number Stored as Text

Microsoft Excel will display a green triangle on fields where it recognizes a number, but sees that it's stored as text instead of as a number (Screenshot):



Converting Text to Number

There are two easy methods to convert the text field to a number.

Convert to Number Feature

In Excel, first highlight the affected cells (screenshot):



Next, select the Yellow Warning Triangle button:



Select "Convert to Number" and Excel will change the text fields into numerical fields. You may notice that the green triangles go away:



Value Formula Feature

Another easy method is to use the Value Formula in Excel. 

First, create a new column. 
Next, select the top cell and enter the following text:
=VALUE(



Then, click the adjacent cell:



Click Enter to save the changes. 

Finally, apply the same value formula to the rest of the column by copying the cell and pasting into the other cells. This copies the formula to the rest of the cells. (Alternately, you can also select the lower right corner of the cell and drag down.)






    • Related Articles

    • Monthly Support Webinar - April 2021 - Reports

      Reports Webinar On April 28th 2021, SETWorks hosted a live webinar about Reports. You can view the recording from the link below: Topics Discussed Topics discussed include: How to access the Reports tab. How to mark a Report as a favorite. How to ...
    • Reports

      How do I access and use Reports within SETWorks? All Users, Administrators Terminology can be modified within SETWorks to better fit the needs of your organization. If the terminology in our articles are not the same on your site, talk to your local ...
    • Restricted Reports

      Reports with Restrictions Administrators I noticed that some reports don't allow my staff to change the staff dropdown. Why is this? Some reports in SETWorks have limits placed on who is allowed to run the report for all staff.  This is controlled ...
    • Reports - Billing Reports Notes and Errors

      The following Reports use activity record data to generate an exact count of units of service that were provided. This article lists configuration issues that cause a message to appear in the errors or notes field on the report. Are you using ...
    • Electronic Billing (eBilling) Reports

      These two reports compare activity records and payments received and reconcile: Health Care Payment Batch (Reconciliation) Report Health Care Payment Batch (Reconciliation) Report for Excel These reports compare claims that were sent and reconcile ...