Getting false divide by zero in Excel

I have a column of numbers.

When I try calculating the standard deviation in Excel by using STDEV(A1:A97) I get a '#DIV/o!' notice. But there are no zeroes or false values in that range.

All the data is formatted as numbers with 3 decimal places.

What am I missing?

1 answer

  • answered 2018-11-08 09:00 Mate Mrše

    Figured it out.

    The problem was some of the cells contained a carriage return after the number, so I guess Excel counted those as zero.

    After using the TRIM() function, I was able to calculate what I needed.