I am converting the following to numbers using =value(LEFT(D117,LEN(D117)-1))
4"
3/4"
2"

All works fine except the fraction keeps turning into a date value? I try
formatting the cells but this does not work either? Any advice
--
Ray