1 Reply Latest reply on Sep 7, 2006 7:15 AM by jorgepino

    excel formula

    jorgepino
      help!
      I need to create a excel sheet from coldfusion but allow the user to change the formula
      I was able to to that the problem i am having is how to add the % sign to the cell with out getting errors

      firstcell = 1 // firstcell toread
      lastcell = 10 // last cell to read
      <cfoutput>
      =Round(a#firstcell#/a#lastcell#%,2)
      </cfoutput>
      this will give me something like
      44.50 but I needed to show as 44.50%
      I try to get info from excel but I am havig some problem finding the answer

      thanks