Hi Aloy,

Thanks for the advice, unfortunately where I am they are using a DB/2 
database, and using some form of RPG and BPIX to return the data and they 
cant pre-format it for me. HOwever I have now got a solution though 
cluncky in that I have to use the textmatrix property of the cell.

Regards
Bill Crawley


> Use "Format" in your SQL string to load data in your grid e.g.
> 
> SELECT Format(Field1,"##,##,#0.00") FROM TableName
> 
> Regards.
> Aloy
> 
> ----- Original Message ----- 
> From: "Bill" <william.crawley@u...>
> To: "professional vb" <pro_vb@p...>
> Sent: Friday, November 16, 2001 3:42 PM
> Subject: [pro_vb] MSHFLEXGRID column formatting
> 
> 
> > Hi all,
> > 
> > How do I format a Column on a hierachical flexgrid at runtime.
> > 
> > I.e. I have a numeric column and I want to format it in the 
> > form '##,##,#0.00"
> > 
> > Regards
> > Bill Crawley
> 
> 
>