Respected Eileen’s Lounge Members,
I have an Excel File where cells in a particular column is formatted in TEXT, and cell are filled with 16 Digit Number started and end with DOT. I need to remove that DOT and I have used Excel Replace system to remove that DOT from every CELL, after using Excel Replace System both DOT are being removed from the CELL, but 16 Digit Number is changing in to 7E+15. Now I want a system (Excel Formula / VBA Code) by which the DOTS to be removed from the CELL s while the 16 Digit Number remains exactly the same. CELL may be up to 30000 No's . Hope I will get help to solve this problem of course.
With Humble Regards
tarun@1964
Excel
-
- Administrator
- Posts: 78788
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel
Run this macro:
Code: Select all
Sub RemoveDots()
Dim r As Range
Application.ScreenUpdating = False
For Each r In Range(Range("B2"), Range("B2").End(xlDown))
r.Value = "'" & Replace(r.Value, ".", "")
Next r
Application.ScreenUpdating = True
End Sub
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 24
- Joined: 10 Jun 2022, 09:22
- Location: KOLKATA , WEST BENGAL, INDIA
Re: Excel
Respected Hans_Vogelar Sir,
You have done me a great favor in this matter of mine, although You have done it many times before. of course Your solution/Tips or Answer according to my problem has always been the best Answer or Solution/Tips for me. i have no wards to thank You
With Most Humble Regards
tarun@1964
You have done me a great favor in this matter of mine, although You have done it many times before. of course Your solution/Tips or Answer according to my problem has always been the best Answer or Solution/Tips for me. i have no wards to thank You
With Most Humble Regards
tarun@1964