Results 1 to 4 of 4

Thread: [RESOLVED] Currency Format..

  1. Jun 11th, 2006, 02:46 AM #1
    nagasrikanth
    nagasrikanth is offline

    Thread Starter
    Hyperactive Member nagasrikanth's Avatar
    Join Date
    Nov 2004
    Location
    India,Hyderabad.
    Posts
    420

    Resolved [RESOLVED] Currency Format..

    Hi I want to show some data in currenct format in my form..Iam doing this by using
    VB Code:
    1. format(1000,"Currency")

    with this im gettig $1000 ..but according to the requirement it should not be "Dollor" it should be "EURO (€)"

    So what i have to do for this???Please help me..

    thanx & regards
    Srikanth
    The Difference between a Successful person and others is not a Lack of Knowledge,
    But rather a Lack of WILL
    Reply With Quote Reply With Quote
  2. Jun 11th, 2006, 05:55 AM #2
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Currency Format..

    Hi,

    Is this actually in a VBA Userform or in an Excel cell?

    If in a userform:

    VB Code:
    1. Label1.Caption = Format(Label1.Caption, "€ #,##0.00")


    If in a cell:

    VB Code:
    1. Selection.NumberFormat = "[$€] #,##0.00"

    or replace Selection with the cell or range reference.


    The Currency format works from your Windows locale settings and can't be directly changed.


    zaza
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes
    Reply With Quote Reply With Quote
  3. Jun 11th, 2006, 11:05 PM #3
    nagasrikanth
    nagasrikanth is offline

    Thread Starter
    Hyperactive Member nagasrikanth's Avatar
    Join Date
    Nov 2004
    Location
    India,Hyderabad.
    Posts
    420

    Red face Re: Currency Format..

    hi zaza...

    Thanx 4 that..Its worked for me..thanQ.
    The Difference between a Successful person and others is not a Lack of Knowledge,
    But rather a Lack of WILL
    Reply With Quote Reply With Quote
  4. Jun 12th, 2006, 01:37 PM #4
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Currency Format..

    Glad to have helped. Don't forget to mark the thread as Resolved...
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width