Copying a decimal value from a cell set to show only N decimal places of that value actually copies to your clipboard what's shown, not the raw value. The same happens when downloading a sheet as a CSV. Actual cell values are substituted by what's set to show (i.e. limited number of decimal values).

Is there a way to copy/download actual cell values for decimal numbers without having to update the cell's shown decimal places?

Thanks!

Copying a decimal value from a cell set to show only N decimal places of that value actually copies to your clipboard what's shown, not the raw value. The same happens when downloading a sheet as a CSV. Actual cell values are substituted by what's set to show (i.e. limited number of decimal values).

Is there a way to copy/download actual cell values for decimal numbers without having to update the cell's shown decimal places?