User Profile
davidmgahan
Copper Contributor
Joined Oct 09, 2024
User Widgets
Recent Discussions
Re: Impossible to sum numbers in Excel
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. David269Views0likes0CommentsRe: Impossible to sum numbers in Excel
HansVogelaar Thank you for your reply. I've tried that but I am messing up somehwere, I think. I am unsure how to do one step in your instructions: Next, clear the 'Find what' box and paste ‑ into it (warning: this is not the standard minus sign, it is a non-breaking hyphen!) Can you tell me how to do that? (I've tried pasting a non-breaking hyphen symbol into a blank cell and then copy / pasting that into the 'find what' box and continued to the last step in your instructions (replace with a standard minus in the 'replace with' box but that doesn't seem to work for me).320Views0likes3Comments
Recent Blog Articles
No content to show