How do you export a number field into excel without the commas

[jdelaguila]

Alteryx Community,

I have a zipcode field that I need to export into excel as a numeric field, however Alteryx is adding in the commas into the number field.

Is there a way to export a field out into a .xlsx file as number field - WITHOUT the commas?

I attached a workflow to show you whats happening.

Thanks again for all the help.

Javier

[ImadZidan]

Hello @jdelaguila ,

What about the numbers with the dash in between?

[phottovy]

Hi @jdelaguila,

Are you using the reporting tools to create the spreadsheet or are you using an output tool?

[jdelaguila]

I don't need the dashes actually - i figured i could get rid of that using the cleansing tool. I'll be keeping the first 5 digits of the zipcode only. 

So i would love to export out the zipcode '22310' as a number instead of '22,310'

[jdelaguila]

Right now i'm using an output tool - but would be okay using the reporting tool if that would fix the problem. 

[phottovy · Accepted solution]

I actually don't have the issue with the normal output tool. Here is what my output looks like using the attached workflow. Can you show what yours looks like?

[jdelaguila]

Well thats interesting. So in Alteryx it shows up like this:

But then it exports out like this:

I was assuming my last select tool view was what was going to export - but looking at it in Excel it all looks good. At the end of the day it works. Thanks for the quick response once again! 

Javier