topic Excel formula problem. in Product Forum https://community.blueprism.com/t5/Product-Forum/Excel-formula-problem/m-p/63954#M16809 <P>Hi,&nbsp;<BR /> <BR /> I have a problem when posting a formula to excel. Getting an 0x800A03EC error in one case (when posting the original format after changing which cells I'm referring to) and #NAME? error when posting with "," instead of ";" that i tried because of divider problems. Even if i just read then post the formula without manipulate it i get the 0x8... error.<BR /> <BR />The formula in question:&nbsp;<SPAN style="background-color: #ffffff;">=INDEX(B2:B7;TYPVÄRDE(PASSA(B2:B7;B2:B7;0)))</SPAN> and it works if i post it manually to excel.<BR /><BR /> Running windows 10 with Swedish language and localization and Swedish excel.&nbsp;<BR /> <BR /> I need to find a solution since i can't change anything but the language due to not knowing the impact of changing for instance format setting has for the applications I'm using in the automations.<BR /><BR />Anyone has any tips regaring this?<BR /><BR /><BR /></P> <BR /><BR /><BR />​<BR /><BR />------------------------------<BR />Daniel Litfeldt<BR />------------------------------<BR /> Fri, 13 Sep 2019 09:50:00 GMT DanielLitfeldt 2019-09-13T09:50:00Z Excel formula problem. https://community.blueprism.com/t5/Product-Forum/Excel-formula-problem/m-p/63954#M16809 <P>Hi,&nbsp;<BR /> <BR /> I have a problem when posting a formula to excel. Getting an 0x800A03EC error in one case (when posting the original format after changing which cells I'm referring to) and #NAME? error when posting with "," instead of ";" that i tried because of divider problems. Even if i just read then post the formula without manipulate it i get the 0x8... error.<BR /> <BR />The formula in question:&nbsp;<SPAN style="background-color: #ffffff;">=INDEX(B2:B7;TYPVÄRDE(PASSA(B2:B7;B2:B7;0)))</SPAN> and it works if i post it manually to excel.<BR /><BR /> Running windows 10 with Swedish language and localization and Swedish excel.&nbsp;<BR /> <BR /> I need to find a solution since i can't change anything but the language due to not knowing the impact of changing for instance format setting has for the applications I'm using in the automations.<BR /><BR />Anyone has any tips regaring this?<BR /><BR /><BR /></P> <BR /><BR /><BR />​<BR /><BR />------------------------------<BR />Daniel Litfeldt<BR />------------------------------<BR /> Fri, 13 Sep 2019 09:50:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-formula-problem/m-p/63954#M16809 DanielLitfeldt 2019-09-13T09:50:00Z