=TEXT(A1,IF(ISNUMBER(FIND(".",A1)),REPLACE(REPT("0 ",LEN(TRIM(A1))),FIND(".",TRIM(A1)&"."),1,"."),REP T("0",LEN(TRIM(A1)))))

I have an excel function to get number value from text formatted cells
But sometimes it has 1/2 like values in cells. Then the output value
displays like 39479
Is there any way to avoid this?
Pls Help..