Table Render automatically placing comas in number field

Hi,

I've created a workflow that outputs my data into a table.

When i go to render the table into an Excel file, it automatically places my int field (8 characters) into **,***,*** format.

Having looking at the properties of the table i cant seem to find a fix for this anywhere, hopefully its just me.

EDIT: Is there a way to remove the comas from the field so the output is (12345678) rather than (12,345,678)

Thanks for any help provided.

Publish

Workflow

Settings

Bug

Accepted answers

mceleavey

Actually, you can select "Microsoft Excel Legacy (*.xlsx)" on your output and select "Delete Data & Append" and it will overwrite what's there while retaining the format. You need to name the cell range in Excel and output to that named range as the sheet/range name.

This will allow you to retain the Excel format;

If this option does not appear, download the Access 2010 (32 bit) driver.

All comments

mceleavey

Hi @PasqualeBasile,

Could you give a bit more detail around what the problem is?

I'm not sure from your description what's wrong.

If you could provide the workflow, and just some junk data I can have a look.

Thanks,

EDIT: I get it now. I'll have a look.

PasqualeBasile

Apologies i have edited the post to try make it a little clearer.

mceleavey

Hi @PasqualeBasile,

When outputting into Excel it will take the data type and render it according to your default settings within Excel. In this case, it's recognising you're outputting a numeric value and applying the numeric mask by default.

The easiest fix is to convert the number to a string before output, if that's applicable.

The other method is to update an existing Excel sheet with the new data inputting into a named range is pre-formatted. This will then paste the new numbers in whilst retaining the original format. You can then set the numeric format in Excel.

Hope this helps,

PasqualeBasile

Hi M,

Thanks for your post, it makes a lot more sense now as to why this is happening.

I tried the second method however as the render tool replaces the file / sheet when run the pre-formatted range is reset.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703