Format display in DBGrid cell? (D2007 and Vista)

I display (and shall process) data from an Excel workbook using TADOConnection, TADOQuery, TDatasource and TDBGrid.

My problem is that one of the columns in the workbook is formatted as Currency with two decimals, but in the DBGrid both the currency prefix and any trailing decimals equal to zero are suppressed. I don't care about the currency prefix in this display, but I should very much like to have both decimals shown whether or not they are zero.

I had a similar situation with another program connecting to an Access database. In that program I already used TADODataset (instead of TADOQuery) and was told how to control the DBGrid display using the fielddef properties in TADODataset. Is this how I must do it here as well or can I do it (the simpler way?) with TADOQuery?

regards Sven

.

Relevant Pages

  • Importing data from excel into word
    ... I have a vast amount of data in an excel workbook, and need to export it to ... but it needs reformatting for display and simplicity purposes. ...
    (microsoft.public.word.docmanagement)
  • VBA coding to retrieve data from Access to Excel :S
    ... program to bring data from a database where the program using the SETUP ... sheet from the excel workbook as its critaria and then populates the ... DATA sheet. ... I then can use the DATA sheet to display data in the ...
    (microsoft.public.excel)
  • Displaying Multiple Excel files, Not plotting zero values
    ... How ccan I display more than one Excel workbook in different window? ...
    (microsoft.public.excel)
  • memory low error when inserting object
    ... I am trying to an embed an excel workbook into a power point presentation ... My problem is that when I target the object (I want to display as an icon) ... and try to insert it I get an out of memory problem. ...
    (microsoft.public.powerpoint)