I'm using the excellent CMDExcel to write worksheets for our accounts package. However there's on thing catching me out.

Our AR account number is in the form nnnAnnn where the A represents the first letter of the account name. Unfortunately we have some accounts in the 105Ennn range. As you can imagine Excel treats that as scientific notation, 105E17 shows as 1050000000000000000000, or something like that.

I've ploughed through CMDExcel and Excel12 packages and can't find how to set that column as text. Anybody done this?