Forum Discussion
Impossible to sum numbers in Excel
I hope someone can help with this because I am pulling my hair out. When I try to sum numbers in a column, at the bottom of the page it gives me a count and not a sum. When I try to Autosum, it g...
@davidmgahan
Hello David,
I suggest you use the method I mentioned earlier.
Open your file on excel desktop.
Save your file as a tabulation separated txt.
You will see that your file has the numbers saved with those odd little symbols.
CTRL + A
CTRL + H
Find " replace with (nothing)
Find ? replace with (nothing)
Once it's done, do the following:
CTRL + A
Copy
Open Excel
Paste as values.
It worked for me
Hi Terryloo,
Thank you for your help.
I tried that but to no avail.
Can you confirm I should save the file as a type "Text (tab delimited .txt" file? or can you tell me the extension I should see in the save as options?
When I saved it as as .txt file, there were only ? in from of the numbers but no " symbols and when I did the step 'replace with nothing' all the data disappeared from the sheet.
Thanks again for helping.
David
Thank you for your help.
I tried that but to no avail.
Can you confirm I should save the file as a type "Text (tab delimited .txt" file? or can you tell me the extension I should see in the save as options?
When I saved it as as .txt file, there were only ? in from of the numbers but no " symbols and when I did the step 'replace with nothing' all the data disappeared from the sheet.
Thanks again for helping.
David