Forum Discussion
Problem in totalling columns in excel due to format issue
I have a large database containing two files and I am trying to merge them through "Index , match" function and then sum up values in a resultant column. The data from both files is from a PDF file c...
Try the following:
- Select a single column with numbers that won't format.
- On the Data tab of the ribbon, click Text to Columns.
- Select Delimited, then click Finish.
Does that convert the values to real numbers?