>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

try

with CellReference
   .Value = mvalue
   .NumberFormat = '[$€ ]#,###.00' + '_);[Red]([$€ ]' + '#,###.00' + ')'
  or
    .NumberFormat = '[$€ ]#,###.00' + '_);[Red][$€ ](' + '#,###.00' + ')'
endwith