BSALV
Banned user
- Joined
- Oct 31, 2010
- Messages
- 1,651
- Office Version
- 365
- 2013
- 2007
When i use the XL2BB-tool to download data from this site in my workbook in "dutch" regional setting, the formulas remain english and therefore unprocessed.
* Is it possible to change my setting to english, import the XL2BB-data and switch back to dutch ? (= just english setting during 30 seconds !!! )
* Later, to share the results here on the site with that same XL2BB-tool, to do just the same, switch to english and use the XL2BB-tool, because yesterday i saw that conditional format formulas remained in dutch.
Should that even be possible, to make a macro to make that switch forwards and backwards automatically ?
example of such a XL2BB-import, the formulas are kind of strings
* Is it possible to change my setting to english, import the XL2BB-data and switch back to dutch ? (= just english setting during 30 seconds !!! )
* Later, to share the results here on the site with that same XL2BB-tool, to do just the same, switch to english and use the XL2BB-tool, because yesterday i saw that conditional format formulas remained in dutch.
Should that even be possible, to make a macro to make that switch forwards and backwards automatically ?
example of such a XL2BB-import, the formulas are kind of strings
Map2 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
I | J | K | L | M | N | O | P | |||
11 | =IF(F11,$B$1,0) | =PRODUCT(G11,$B$2) | =SUM(I11,J11) | =SUM(C11*$B$3,B11)*$B$4 | =PRODUCT(G11,$B$5) | =SUM(K11,L11,M11) | =IF(B11<=$E$4,$F$4,IF(B11<=$E$5,$F$5,IF(B11>=$E$6,$F$6))) | #WAARDE! | ||
Blad1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
P11 | P11 | =N11-O11 |