I am trying to write a formula in excel.
Formula is =text(a1,“000000”)
the problem is the fill range needs it to be written as a string.
It obviously doesn’t like the embedded “” but i tried to write it as “=text(a1,'”‘0000000’“')” but that doesn’t work.
If also tried “=text(a1,‘“000000”’)” which doesn’t work either.
Any suggestions?
Use write cell and write the formula in first cell…
Then use auto fill range to fill the first cell till bottom
Cheers
that doesn’t help because i still need to write the formula out and it has the double quotes in there. the error is on the double quotes.
Double quote will not crwate an issue
This is how you need to write
"=Text(A2,""00000"")"
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.