Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Round Numbers To 7 Digits In Crm Export Text

Paste the formula into the first output cell, then fill down to apply it to your range.

Round values to 7 digits in crm export text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Round numbers to 7 digits in crm export text.

ExcelGoogle SheetsWPS

=ROUND(A2, 7)

Round values to 0 digits in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Round values to 1 digits in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Round values to 2 digits in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Round values to 3 digits in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Round values to 4 digits in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Round values to 5 digits in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.