I am working on ASP project that will be used in France, Beljium and US. I am using Office web component (Spreadsheet 9) to design a grid. I have to display Amount in local currency format. For ex.

France €100 0,00

Belgium €100.0,00

US $100,0.00

I am using NumberFormat function. But it is converting Amount into $ and not to €.

Can anybody guide me to format this Amount column. I want to know is there any built in function available or can I use any user defined function.
How can I bind user defined format to this column?

I'm not familiar with a program named Spreadsheet 9. But, if it's an Office program as you said, there should be a Help button. Just type in keywords to your problem. Also, try looking in the format menu

Perhaps these articles about LCID regional settings will give you some ideas:

Using the Locale Identifier (LCID), Part 2 by Scott Mitchell
http://4guysfromrolla.com/webtech/031401-1.2.shtml
Session.LCID = 1061 'Estonian Locale ID

HOWTO: Set the ASP Locale ID Per the Browser's Language Settings
http://support.microsoft.com/?id=229690
When you create an Active Server Pages (ASP) application that multiple internation sites access, it is beneficial to modify the Locale settings so that the VBScript Date, Time, Currency, and so forth formats return the correct format for the location of the user.

Visual Basic Scripting Edition - Locale ID (LCID) Chart
http://msdn.microsoft.com/library/de.../vsmsclcid.asp
English - United Kingdom is 2057
English - United States is 1033