MSFlexGrid text formatting?

How do you format text in the MSFlexGrid?

I'm pulling displaying prices out of a database but they are not showing up in a currency format. I want to show:

$1.50

not

1.5

I can't seem to find any means of formating the text in the FlexGrid. The prices are in currency format in the database, so why doesn't it just use that format?

Any help would be appreciated..

Dan

When fillin grid from your database, use format
(ie format(rst!YourFeild,"currency"). This works if your filling by row but I havn't figured out how to do it using the Db Control.