I am using a custom app to export data from asp.net/silverlight to excel using an xslt mapping - the requirement is that the dates and numbers must be formatted to the client's regional settings. This works great! Except that I have a need to concatenate 2 hidden fields into one visible field. One is a number/currency formatted with 2 decimal places (keep in mind, different cultures use different decimal formatting - sometimes a . sometimes a , etc), the other is the currency code (e.g. USD, GBP, etc). It works to concatenate (e.g. =CONCATENATE(P7," ", Q7)), but it drops the 0 decimal places which I want to keep for formatting. I cannot figure out how to do this using a forumla and keep the regional number format (e.g. this does not work =CONCATENATE(TEXT(P7,"#####0.00")," "; Q7) for some regions). I cannot use VBA (another requirement). Any ideas?
Much appreciated!
-M
Much appreciated!
-M
