>hi all,
>I have an app that creates an excel file and everything hunky dorey except one thing. the customer wants to see 2 decimal points in a numberic field and also a lead char of the euro sign. i have tried passing in the values below but all that shows up in excel is the value without the euro sign. has anyone any ideas? Idealy automatically formating the cell to numeric with 2 decimal places and using the euro symbol would be best i think but i don't know now to do it.
>
>"€ " + ALLTRIM(STR(mvalue,9,2))
>
>~M
oExcel.ActiveWorkBook.ActiveSheet.Columns("A:A").Select
oExcel.Selection.NumberFormat = "[$€ -2] #,##0.00"
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
