A clarification on how to handle the issue if you encounter a problem with summing cells in Excel after exporting a report from Qoyod. If after you export an Excel file from Qoyod and try to sum the cells, the total comes out as zero, the reason is that Excel treats the numbers as text.
This prevents summing and gives you a zero result even if the numbers appear correct.
Step-by-Step Solution
-
Select the cells containing the numbers that show a green indicator next to them.
-
You’ll notice a small yellow triangle next to the cell.
-
Click on the triangle and select Convert to Number.
-
After the conversion, try summing again, and the correct result will appear.
Additional Notes
-
Sometimes the data imported from Qoyod is already in text format due to the format or formatting.
-
If you have many cells, you can select the entire column and apply Convert to Number at once.
Keywords for Inquiry
Why does the total in Excel come out as zero?
Excel won’t sum the cells after exporting from Qoyod.
How do I fix the numbers in Excel after importing?
The file shows numbers but the sum gives zero.
