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?
全站熱搜