Type into throws Argumate 'Text': (2): error BC35012: Option Strict on disallows implicit conversion from 'Double' to 'String' and from 'String' to 'Double'

[Nyx (Arnel Terblanche)]

Hi,

Im trying to type / write the following formula into a cell in excel, but I get the error above. I have tried the string.format and the .tostring but nothing seems to work. Please help?

=TEXTJOIN(“-”,MID(G17,{7,4,1},{4,2,2}))&RIGHT(G17,9)

[arjunshenoy]

Hi @Nyx

When you encounter the error Option Strict on disallows implicit conversion from ‘Double’ to ‘String’ and from ‘String’ to ‘Double’, it means there is a type mismatch between variables or expressions.

Please the following modified expression a try:

"=TEXTJOIN(""-"", MID(G17, {""7"",""4"",""1""}, {""4"",""2"",""2""})) & RIGHT(G17, 9)"

Best Regards.

[fernando_zuluaga]

Hi @Nyx

Give a try with

"=TEXTJOIN(""-"",MID(G17,{7,4,1},{4,2,2}))&RIGHT(G17,9)"

Regards!

[Nyx (Arnel Terblanche)]

Recording the type into formula bar activity worked