Currency Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is a pretty simple issue to solve...but i can't seem to figure it out!!
I want data in some columns to show as currency so I set the format
of a column to currency through code by

myGrid.cols(ColIndex).format = "c

Then I manually add rows to the grid...but when I look at the currency
column, I see that the data is not formatted - it still shows up as a numeric
value without the "$" sign

I even tried to format the data before inserting it into the grid by:
myData = Format(myData, "c") - this doesn't work either..

Does anyone know why the format function is not working

Parvee
 
Try FormatCurrency.

(I'm sure someone will also have a convoluted reg expression version
also, but if you want working code fast use my suggestion)
 
Back
Top