Some users want to filter or edit the spreadsheet. When I change the format from scientific notation to text or numeric some how the last digit in all the...

yes, I save it as a csv and then open using Excel.

Thanks. I closed the application and re-opend it. That somehow fixed it.

thank you very much for your reply.

Thank you for your response. I used your expression with 'countdistinct' and it worked great.