I've connected my Excel worksheet to a MySQL (actually MariaDB, but same/same) database.
This is using the MariaDB ODBC drivers, via a ADODB.Connection.

The records are coming back with the wrong decimal place.
The MySQL field has type Decimal(19,2)
Numbers like 56.29 are fine.
But 1.00 in the database is coming through to excel as 0.01
Or 22.00 is 0.22

Any help would be much appreciated