Quote Originally Posted by andy photenas View Post
I am trying to do this without entering any numbers . I find every time i do this many i mess a few of them up . I am building large kitchens so i have over 300 parts on each of these lists. (and thats just door/drawer parts)
Can that format command you mention work if the 5 5/8 number is there and then you do the formatting you explained?
I am really new to spreadsheets in general so i am learning as i go, and there seems a lot to learn on google sheets!
Thanks a ton for trying to help me out with this !
You would have to write a custom formula to convert. Or you could break the column into two columns (whole number and fraction) and then combine to make it a decimal number. My recommendation is the latter but going forward, always enter numbers as decimal numbers then you can change the way they display.