format number....

Hi all and sorry for my english...
I 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?

WITH Worksheets("CONTROLLO").Range("A65536").End(xlUp).Offset(0, 4)
.Value = IMPORTO_M
.NumberFormat = "#.##0,00"
END WITH



"sal21" wrote:

>
> Hi all and sorry for my english...
> I 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?
>
>
> --
> sal21
>
>
> ------------------------------------------------------------------------
> sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
> View this thread: http://www.excelforum.com/showthread...hreadid=392063
>
>