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
HansVogelaar's avatar
HansVogelaar
MVP
Jan 31, 2023

wmcfall Select the values in a column.

On the Data tab of the ribbon, click Text to Columns.

Select Delimited, then click Finish.

If necessary, repeat for other columns.

  • 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???

Resources