I have attached a file.
Pls take a look
Column A is the raw data i pulled out from the database.
I need to convert them into format in Column B.
For instance, the raw data is 1.236,000
it represents 1236
I need excel to trim of all the back portion of ,000 and regognise 1.236 as 1236.
Bear in mind that i would need to values for calculation. I tried dividing by 1000, dun think it helps.
My raw data goes up to as high as 4500 records.