Hi,
I want to select a number with 0's after its decimal point.
For example, if I have incoming data as 16.90, 17.00, 17.10, 17.20, 17.30, ......, 17.90, 18.00, 18.10, 18.20, ......., 18.90, 19.00, 19.10, ......... and so on. I want to select only numbers 17.00, 18.00, 19.00, ..... from this series.
How could this be done..?? Any help plz....
frnds2vivek
0
Light Poster
Recommended Answers
Jump to PostAssuming that all your numbers will be in the same format, less than 100 and in a listbox, use the following mid statement...
Dim xCount As Integer, strNuls As String For xCount = 0 To List1.ListCount - 1 List1.ListIndex = xCount If Mid$(List1.Text, 4, 2) = "00" …
All 6 Replies
AndreRet
526
Senior Poster
frnds2vivek
0
Light Poster
AndreRet
526
Senior Poster
frnds2vivek
0
Light Poster
AndreRet
526
Senior Poster
frnds2vivek
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.