Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format string (2000)

    I import from text file this string similar and store in var IMPORTO:

    0000000101400
    0000000202600
    0000000087233
    0000000068200

    i want in a cell:

    1.014,00
    2.026,00
    872,33
    682,00

    how to?

    note: to be sure to get all i ahve used this:
    IMPORTO = Mid(Record_Corrente, 34, 13)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format string (2000)

    Use something like

    With Range("A1")
    .Value = Val(IMPORTO) / 100
    .NumberFormat = "#,##0.00"
    End With

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format string (2000)

    genius!
    WORK PERFECT.

Posting Permissions

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