Forum Discussion
Solved
Cells not summing properly
Sometimes when I download excel table from Real Page financial software, the excel file will not allow me to highlight the cells and sum the numbers in them in the bottom right bar of excel. I only ...
That probably means that Excel sees the values as text instead of as numbers.
Try the following:
- Select such values in a single column.
- Make sure that the number format is set to General or Number.
- On the Data tab of the ribbon. click Text to Columns.
- Without changing any settings, click Finish.
Can you sum the values now?
That probably means that Excel sees the values as text instead of as numbers.
Try the following:
- Select such values in a single column.
- Make sure that the number format is set to General or Number.
- On the Data tab of the ribbon. click Text to Columns.
- Without changing any settings, click Finish.
Can you sum the values now?
This did work - but do you know why these steps became necessary? I can't figure out why it suddenly just stopped auto summing correctly. I updated excel, I restarted it. I just can't figure out why these extra steps became necessary. Thoughts? Thanks
It depends on how the source data are formatted. Sometimes Excel interprets values as text if they come from another application or from the web.
I see. That would apply to my document. It was an import from the bank.
Thanks for the response.