Sum brings back null Value
Hi,
I just worked out a way round it.
I had a "$" in front of the number so it wouldn't sum. I removed the "$" and
now it works.
"RedDevil" wrote:
Hi,
I'm trying to sum in an imported excel file but it brings back a zero value
when there is numeric data in the selected cells.
Is there a work around as I've copied and pasted the sheet into a new excel
worksheet as "Paste Special" "Values" and I still can't get excel to
calculate the cells.
thanks
RD
|