Significant Figures

[ppadmore]

Hello everyone.

We get lab data reports which have data in the form of

"<0.00657," or 4.2, 300, etc.

How do I create a spreadsheet which will automatically count the number of non- zero digits and display the correct significant figures?

Thanks!

Penny

[Portuga]

Can you define "Non-zero digit numbers"?

[protonLeah]

You can format the cells for scientific notation, but, then you will have to strip off the <'s, etc.