I am trying to write an excel file in which I must place a ####. ### 0 format number within a specific column of the table, this number is contained in a data table. The problem is that at the time of writing the number in the cell in “general” format, delete the number 0 at the end of the number chain and I need that 0 to be there.
Already trying to change the cell format to “text” before writing, the problem is that when I write the data table inside Excel using Write or Append Range, the cell returns to the “general” format even though before writing I had it as “text.”
Does anyone have any idea how to solve the problem?