Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005

    Unhappy Unanswered: Data Formatting in spreadsheet 9

    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?

  2. #2
    Join Date
    Nov 2005
    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
    Programming/Web Design

    Offer solutions-not criticism.

  3. #3
    Join Date
    Jun 2003
    Perhaps these articles about LCID regional settings will give you some ideas:

    Using the Locale Identifier (LCID), Part 2 by Scott Mitchell
    Session.LCID = 1061 'Estonian Locale ID

    HOWTO: Set the ASP Locale ID Per the Browser's Language Settings
    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
    English - United Kingdom is 2057
    English - United States is 1033
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts