I am binding a mshflexgrid control to an ADO datasource, created through an SQL statement. Is there a way to format a column, for all rows, in the grid?

My specific example is I'm retreiving a numeric department number I'd like to pad with leading zeros. (e.g. 99 displays as 0099) I'm using an ODBC datasource and can't use format$ in the SQL statement.

Any ideas would be appreciated. (Especially if it CANNOT be done, cause I'm tired of looking for an answer...)

Thanks
Tom