Home Forums SQL Server 7,2000 T-SQL INSERT into Excel leaves values as text RE: INSERT into Excel leaves values as text

  • December 14, 2012 at 6:13 am

    #1568661

    You can't even use the values in SUM functions

    well...you can

    =SUM(F2:F6*1)

    or

    =SUM(VALUE(F2:F7))

    all you have to do it convert to a number from text in the formulae