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