Dealing with numeric fields on reports being exported to excel as non-numeric values

it is very useful to export reports to excel but numeric and currency values get interpreted as textual values by default. Our development team is currently reviewing this issue in order to make it disappear. But until that happy day comes, here’s a work-around solution that addresses this nuisance in three easy steps.

Here’s a work-around solution to address this issue.

In the excel worksheet, select all the cells where numbers are being treated like text

Move your mouse pointer along the left edge of the selection area until you see a warning/fix icon

Click on the icon and select “Convert to Number”. All the selected numeric cells will be changed from text to numeric values in one click.

All done!

The step-by-step instructions start after the report has been exported to excel and the excel spreadsheet is open.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s