hi ,
i have two cell one contain value of 12,10 and 20,52 when i try to sum them, i am getting result as 0.
i know that they are formatted as TEXT. but no error triangle appear on top corner??

SO can any one let me know how to store 12,25 format as number??