Excel

[tarun@1964]

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

[HansV]

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

[tarun@1964]

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