Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format number
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 |
#2
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is defaulting to Number format instead of General format | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |