Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I get a part of string from a loop in text file with:
    IMPORTO_OPERAZIONE = Format(Trim(Mid(inString, 88, 24) * 1), "#,##0.000")
    i have dimensioned IMPORTO_OPERAZIONE as double but the code return:
    IMPORTO_OPERAZIONE =2692
    i want to have IMPORTO_OPERAZIONE = 2.692,600
    how to?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Sal,

    I don't have the European settings but from a quick look at your format string you may want to reverse the
    comma & period to "#.##0,000".

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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