Write Cell Excel Formula Issue (=TEXT(Date;"YYYY"))

Help Studio
, , ,
1

Hi,

I want to write the following command in Excel. However, since I cannot type the " symbol, it is written differently in the cell in Excel. How can I fix it?

B" + rowCount2.ToString → output example: B6993

I want to write

“=TEXT(B” + rowCount2.ToString + “,” + ““YYYY”” + “)”

image

existing

“=TEXT(B” + rowCount2.ToString + “,” + “YYYY” + “)”

output in excel
image

2

@ilkeruznglu

you can try like this

for escaping " use ""

let us know the exact formula you need in excel…we can suggest the way you need to write in code

cheers

3

Hi @ilkeruznglu ,

Refer below image.

image
image467×517 42.2 KB

4

Hi. Thanks for comments. I updated and stated what I wanted to write above. There is also an excel image.

5

Hi @ilkeruznglu ,

The Actual syntax of the TEXT function is : * =TEXT(Value you want to format, “Format code you want to apply”)

So, if you want to pass double quotes in the string, Please try with the following syntax.

“=TEXT(B”+rowCount2.ToString+“,”+“”“YYYY”“”+“)”
6

Hi,

Thanks for your help. Workeddd

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.