hey there @lafauriea - just checking in to see how you’re getting along with these two suggestions from Danvers and Moh? Let me know if you still are running into any issues and we’re happy to get you sorted! 

Hi @lafauriea , 

In addition to what @Danvers said (which you should definitely try) you can also add a Formatter by Zapier step and try modifying the number 

This is a great resource to check out for this part. 

https://zapier.com/help/create/format/modify-number-formats-in-zaps

IF this works, then it seems to be a problem with the Excel data. 

Let us know if this works :) 

Hi @lafauriea!

It sounds like you’ve done some great detective work to narrow down the cause of this issue! 

If the information is coming from Excel in the wrong format then that’s where we need to address the issue. You said that you changed the regional parameters, which is what I would recommend, it sounds like that hasn’t stuck for some reason. Could you try both changing the overall sheet settings and also highlighting each column with numbers in and formatting them all individually? I know it sounds like overkill but apps like Excel and Google Sheets can be very stubborn when it comes to formatting. 

If that doesn’t work, you could try creating a whole new sheet, setting all the formatting the way you want to and then pasting the values in from your original sheet. 

I hope that helps, I know how frustrating it is when you’re trying to get spreadsheet apps to do what you need for formatting!