Forum Discussion

wmcfall's avatar
wmcfall
Copper Contributor
Jan 31, 2023

Formulas and Functions

I copied values from an imported spreadsheet onto another to work the data.  When I tried to auto sum the values the total is 0.0 but the formula shows up in the header bar.  It does this even after ...
excel
Formulas and Functions
wmcfall's avatar
wmcfall
Copper Contributor
Feb 01, 2023

HansVogelaar 

When I go to the data tab there is no Text to Columns, instead I see this:

 

 

HansVogelaar's avatar
HansVogelaar
MVP
Feb 01, 2023

wmcfall 

Text to Columns is just visible on the right hand side of your screenshot.

  • wmcfall's avatar
    wmcfall
    Copper Contributor
    Feb 01, 2023
    Thank you for pointing that out. I followed your instructions, but I still end up with an auto sum of zero???
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Feb 01, 2023
      If Text to Columns isn't able to re-evaluate Column C as a number, you may have something else in that column that's causing Excel to see it as text. It may help if you're able to share an anonymized sample workbook with a few of those values from Column C.
      • wmcfall's avatar
        wmcfall
        Copper Contributor
        Feb 01, 2023

        Happy to share Patrick.....thanks

         

        You can view "Book1.xlsx" at: https://acrobat.adobe.com/link/track?uri=urn:aaid:scds:US:0d08d8bb-8adc-4f77-b737-9c726eb40e34Patrick2788 

Resources