Why Alteryx reads non-raw information from Excel?

[Stavi]

Hi,

I have an unusual default design set in my source excel table: the amount of 43000 code is positive, but when clicking the cell we can see at the function row that the raw amount is negative! (Screenshot attached).

Surprisingly, Alteryx attracts the designed positive amount instead of the negative raw amount.

Do you have any idea how to solve that issue?

 

[CainãClímaco]

Hi!

I just had to do something like that.

I used the comments in these links.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Preserve-Formatting-on-Overwrite-to-xl... 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Preserve-Formatting-and-Write-to-Excel... 

I hope it helps.

[Stavi]

Hey,

Thank you !

All the solutions focus on preparation work in the excel file, but since I have over 200 excel files combined together this is not relevant for me