close

the value is the cell is probably really in a text format
I would suggest using
=value(trim(your equation))

quot;Brianquot; wrote:

gt; I have a data table with formulas that is a summary of a group of worksheet.
gt; I have a graph using the summary table as the source and one cell is graphing
gt; as quot;0quot; even though there is a number is the table. All the others are fine.
gt; Any suggestions for the cause of this issue?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()