See:
- United States drug overdose death rates and totals over time#Comparisons to other countries in Europe. Section title may change.
- User:Timeshifter/Sandbox284
Change rates per million to rates per 100,000. Or the reverse. Basically, you are dividing or multiplying all the numbers by 10. You can use free Excel online, free Google Sheets online, or freeware LibreOffice Calc.
| Location | Year | Females | Males | Total |
|---|---|---|---|---|
 Austria
|
2022 | 18 | 65 | 42 |
 Belgium
|
2020 | 7 | 34 | 21 |
| Location | Year | Females | Males | Total |
|---|---|---|---|---|
| Austria
|
2022 | 1.8 | 6.5 | 4.2 |
| Belgium
|
2020 | 0.7 | 3.4 | 2.1 |
Note that for the visual editor to work correctly you will need to put nowiki tags (<nowiki> </nowiki>) around the table templates (if any) just above the table. Remove them when you are done.
Then in the visual editor select and copy just the data cells, but not the years (Ctrl+c). Then paste them (Ctrl+v) into a blank sheet in one of the above spreadsheets. The range will be the same in all 3: A1:C2 for the above example. The basic formulas are: =A1:C2/10 and =A1:C2*10 (all numbers in the range are divided or multiplied by 10).
Click a blank column head to select that column. Then paste the formula in the fx spot above the spreadsheet. Then to get the adjusted data cells to show up:
- In Excel just click enter.
- In LibreOffice Calc click Ctrl + Shift + Enter.
- In Google Sheets click Ctrl + Shift + Enter, and then Enter by itself.
Select and copy the adjusted data cells via Ctrl+c. Then using the visual editor select the old numbers in the wikitable. Paste the new numbers over them via Ctrl+v.