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

1. ## 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. ## 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. ## 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. ## 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
•