Posted to microsoft.public.excel.programming
|
|
format number
-----Original Message-----
in the cloumn C2:C2500 in text format, i have this value
282215,82
8525,73
68574,93
10652,78
2722,29
4075,71
21283,73
....
this number is imported fronm a text file, from this line
var_CAUS = Trim(Mid(riga, 65, 14))
my prob is to insert a "." and trnsform in
282.215,82
8.525,73
68.574,93
10.652,78
2.722,29
4.075,71
21.283,73
automaticly whe the macro import the data string.
---
Message posted from http://www.ExcelForum.com/
.
If Len(var_CAUS)6 Then _
var_CAUS = Left(var_CAUS,Len(var_CAUS)-6) & "." _
& Right(var_CAUS,6)
|