Hi Excel Ninjas,
I have a csv file and i converted it to excel, somehow the price column (E1) looks weird as i can't apply sum formula unlikely on column D. i have tried several ways: text to column, smart tag, paste special, value function, replace comma but none give a proper result. May i know if there is any proper formula?
thanks,
keanur
I have a csv file and i converted it to excel, somehow the price column (E1) looks weird as i can't apply sum formula unlikely on column D. i have tried several ways: text to column, smart tag, paste special, value function, replace comma but none give a proper result. May i know if there is any proper formula?
thanks,
keanur
Attachments

61.7 KB Views: 11