How to Convert Units in Google Sheets Without Losing Significant Figures

Rule Statement

Converting units in Google Sheets without losing significant figures means distinguishing exact conversion factors from measured conversion factors, keeping full precision inside the spreadsheet, and rounding only the final reported value. Google Sheets does not track significant figures; it stores IEEE 754 double-precision numbers and displays them according to cell formatting. Therefore, you must apply the rules yourself.

For multiplication and division, the result carries the same number of significant figures as the factor with the fewest significant figures. Exact conversion factors—such as 1 in = 2.54 cm (exact), 1 lb = 0.45359237 kg (exact), and 1 atm = 101325 Pa (exact)—do not limit significant figures. Measured conversion factors do. For temperature conversions, the additive offset follows addition/subtraction rules: keep the least number of decimal places. See Multiplication and Division and Addition and Subtraction.

In Google Sheets, use CONVERT or manual multiplication for full-precision arithmetic, then use ROUND, TEXT, or custom number formats to present the correct number of significant figures. Never let the default General format silently drop trailing zeros. For a deeper reference, see Significant Figures and Rounding Rules.

Compound units require special care. For example, converting m/s to km/h involves both a length conversion and a time conversion. The exact factors are 1 km = 1000 m and 1 h = 3600 s, so 1 m/s = 3.6 km/h exactly. Keep the full factor 3.6 and apply significant-figure rules only to the measured input. If the input is 12.5 m/s (3 sig figs), the result is 45.0 km/h, which should be reported as 45.0 or 4.50 × 10^1 km/h.

Worked Examples

Example 1: 12.30 m to cm

Input: 12.30 m. The trailing zero is significant, so 12.30 has 4 significant figures. The conversion factor 1 m = 100 cm is exact. Result: 12.30 × 100 = 1230 cm. Because 1230 cm is ambiguous, report it as 1.230 × 10^3 cm. In Google Sheets: =A2*100 gives 1230; format the cell as 0.000E+00 or use =TEXT(A2*100,'0.000E+00') to display 1.230E+03.

Example 2: 5.0 ft to cm

Input: 5.0 ft has 2 significant figures. 1 ft = 30.48 cm exactly. Full-precision result: 5.0 × 30.48 = 152.4 cm. Round to 2 significant figures: 150 cm or 1.5 × 10^2 cm. In Google Sheets, keep the full-precision value in one cell and round in a reporting cell: =ROUND(A2*30.48, 2-1-INT(LOG10(ABS(A2*30.48)))). This returns 150; then use scientific notation to show 1.5E+02.

Example 3: 25.0 °C to °F

Input: 25.0 °C has 3 significant figures. The conversion is F = C × 9/5 + 32. The 9/5 and 32 are exact. Compute 25.0 × 1.8 = 45.0; then 45.0 + 32 = 77.0 °F. The addition step keeps one decimal place, so the result is 77.0 °F. In Google Sheets: =A2*9/5+32.

Counter-Examples

• Rounding before conversion: Convert 3.14159 m to inches. If you round to 3.14 m first, then multiply by 39.3701 in/m, you get 123.621 in. The correct full-precision result is 123.699 in. Rounding early causes double rounding error. See Double Rounding Error.
• Treating an exact factor as limiting: Using 1 in ≈ 2.5 cm instead of 1 in = 2.54 cm exact introduces 1.6% error and limits precision unnecessarily.
• Trusting default display: If you enter 12.30 m and convert to cm, Google Sheets may display 1230, losing the visual cue that the trailing zero is significant. Use scientific notation or a custom format.
• Using CONVERT without checking factors: Google Sheets CONVERT uses exact factors for many units, but compound units and some obscure units may require manual factors. Always verify against SI Prefixes and NIST SP 811.

Convention Comparison Table

Rounding conventions matter when the digit after the last significant figure is exactly 5. The table compares common metrology conventions for rounding 12.45 to 3 significant figures.

For more on these differences, see Rounding Methods and Banker’s Rounding.

Standards Citation

Authoritative references for unit conversion and significant figures include:

• ISO 80000-1:2009, Quantities and units — Part 1: General, Clause 7.3.3 (rounding of numbers) and Clause 7.3.4 (significant figures).
• NIST SP 811, Guide for the Use of the International System of Units (SI), Section 7.9 (rounding of numbers) and Section 7.8 (significant figures).
• ASTM E29-13a, Standard Practice for Using Significant Digits in Test Data to Determine Conformance with Specifications, Section 6 (rounding).
• JCGM 100:2008 (GUM), Evaluation of measurement data — Guide to the expression of uncertainty in measurement, Clause 7.2.6 (reporting uncertainty).

This site is a precision and rounding reference, not just a calculator. The significant figures calculator is built on these rules, but the articles, tables, and worked examples are the core resource.

Common Mistakes

• Letting Google Sheets’ General format hide significant trailing zeros.
• Rounding intermediate conversion results before the final step.
• Applying multiplication/division rules to temperature offsets, which follow addition/subtraction rules.
• Assuming the CONVERT function returns a result already rounded to the input’s significant figures.
• Using approximate conversion factors when exact definitions exist.
• Forgetting that scientific notation is needed to remove ambiguity for numbers like 1230.
• Mixing units in the same column without a unit label, which can lead to misapplied factors.

Practice Problems

1. Convert 0.00450 kg to g. Answer: 4.50 g (3 sig figs).
2. Convert 9.81 m/s² to ft/s². Answer: 32.2 ft/s² (3 sig figs).
3. Convert 100.0 mL to L. Answer: 0.1000 L (4 sig figs).
4. Convert 98.6 °F to °C. Answer: (98.6 − 32) × 5/9 = 37.0 °C (3 sig figs).
5. Convert 2.50 × 10^3 Pa to atm. Answer: 2.50 × 10^3 / 101325 = 0.0247 atm (3 sig figs).

Software Behavior Note

Google Sheets stores numbers in IEEE 754 double precision, giving about 15–17 significant decimal digits. The CONVERT function converts many units using exact factors, but it returns a full-precision number. Cell formatting controls display only. To avoid losing significant figures:

• Keep full-precision calculations in helper columns. Do not overwrite them with rounded values.
• Use =ROUND(value, sigfigs-1-INT(LOG10(ABS(value)))) for final significant-figure rounding. Handle zero separately.
• Use =TEXT(value,'0.000E+00') or a custom number format to display trailing zeros in scientific notation.
• Verify that CONVERT uses the exact factor you expect. For example, =CONVERT(1,'in','cm') returns 2.54.
• For compound units such as m/s to km/h, build the conversion from exact base definitions rather than relying on a single CONVERT call.
• For Excel users, see Excel; the same IEEE 754 and formatting cautions apply.

Quick Reference Table