Converting prices to cents

To convert prices in a column (for example column B) to cents in Google Sheets, follow these steps:

1. Select the entire column B containing the prices you want to convert to cents. Do this by clicking the column letter, for example click "B" to select column B.

2. Click the "Formulas" tab, then select "Replace cell values with" from the "Values and time" dropdown menu.

3. Enter the following formula in the input field: =B1*100

4. Press Enter to apply the formula to the entire column B. This converts the prices from euros to cents.

5. If you want the values in column B to be permanently converted to cents, click "Replace values" in the "Replace cell values with" dialog box. This replaces the formulas with the calculated values so they are no longer recalculated when you use the spreadsheet.

6. If you want to keep the original values in column B, click "Cancel" in the "Replace cell values with" dialog box. The formulas are then preserved so you can recalculate the values whenever you want.

There is also a variant where the converted prices in cents end up in column C and you can delete column B afterwards:

1. Select the entire column C. Do this by clicking the column letter, for example click "C" to select column C.

2. Click the "Formulas" tab, then select "Insert cell values" from the "Values and time" dropdown menu.

3. Enter the following formula in the input field: =B1*100

4. Press Enter to apply the formula to the entire column C. This converts the prices from euros to cents and displays them in column C.

5. If you want to delete column B, click the "Data" tab and select "Delete columns" from the "Rows and columns" dropdown menu.

6. Select the columns you want to delete (in this case column B) and click "Delete". This removes column B and shifts the remaining columns to the left, making column C the new column B.