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

    peraphs i am a stupid! alwauys on format number... (2000 sr 1)

    get the value from a txt file with:
    IMPORTO_M = Mid(Record_Corrente, 77, 15) * 1

    Ths number into txt file is 000000001245581

    I multiplicate this number value * 1 to have the absolute value

    1245581

    After i put this number into a column with:

    Worksheets("CONTROLLO").Range("A65536").End(xlUp). Offset(0, 4) =
    IMPORTO_M

    The column is in txt format.

    How to have this?:

    12.455,81

    Wath is the format number?

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

    Re: peraphs i am a stupid! alwauys on format number... (2000 sr 1)

    Note for others reading this: Sal uses continental European number formatting, with comma as decimal separator and point as thousands separator.

    Apparently, you want to divide the number by 100, so you must use

    IMPORTO_M = Mid(Record_Corrente, 77, 15) / 100

    The format for column A is Number, with 2 decimal places (posizioni decimali), and use thousands separator (usa separatore della migliaia)

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

    Re: peraphs i am a stupid! alwauys on format number... (2000 sr 1)

    By the way, you asked something similar about a month ago in post 496,140.

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

    Re: peraphs i am a stupid! alwauys on format number... (2000 sr 1)

    sorry if i have repeat the post...

Posting Permissions

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