Forum Discussion

Lorraine Calvey's avatar
Lorraine Calvey
Copper Contributor
May 07, 2018

Adding decimal amounts together

I am trying to add a column of numbers together using Autosum, but it ignores any figures that includes a decimal point (i.e 10.25).

 

I have tried converting text to columns options and changing the format of cells to numbers, general and currency.

 

How can I fix this?

 

 

  • Lorraine,

     

    maybe your system doesn't use the . (point) as the decimal separator but the , (comma).

     

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Lorraine,

     

    maybe your system doesn't use the . (point) as the decimal separator but the , (comma).

     

    • Lorraine Calvey's avatar
      Lorraine Calvey
      Copper Contributor

      Thanks! That was exactly it! Dont suppose you know how I can change it so it recognises decimal instead of comma in the future?

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        As variant it could be

        =SUMPRODUCT(VALUE(SUBSTITUTE(<your range>,".",",")))

        instead of SUM. If that's the only you'd like to do with these numbers.