Hi, I have few queries regarding Render Tool: * The output which came out was as per my requirement but all numbers which were more than 9,999 are not in number format instead they are in Text format, due to which I was not able to apply mathematical operations in excel output. * Also, just want to know, how can we export output using Render Tool Also, attached is the workflow which would help for better understanding. Thanks Sushant Render Tool.yxzp

Why some numbers are in Text format

Sushantmutreja1

Hi,

I have few queries regarding Render Tool:

The output which came out was as per my requirement but all numbers which were more than 9,999 are not in number format instead they are in Text format, due to which I was not able to apply mathematical operations in excel output.
Also, just want to know, how can we export output using Render Tool

Also, attached is the workflow which would help for better understanding.

Thanks

Sushant

Render Tool.yxzp

Reporting

Accepted answers

danrh

As odd as it sounds, it looks like this is caused by the wrap-text functionality in Excel. In your Render tool, change the width of your paper size. All I did to your original workflow was switch from Portrait to Landscape and it resulted in numbers:

Whatever width you pick, just make sure there's enough room for your data.

All comments

vishwa_0308

Hi @Sushantmutreja1,

1. In select tool only you can change the type as u required.

2. In render tool select choose specific format then you can export it in various formats.

thanks

Vishwa

Sushantmutreja1

Thanks Vishwa but my concern is - some of numbers in "Value" column are in text format and some in Number (Double) format.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703