I am a cad guy by trade and I am trying to make a spreadsheet of items we use. I want to have a few columns that are formatted to be dimensions. Is this possible? Assuming that 12"=1'-0" and such? so if I enter 37 as my number it converts and displays as 3'-1"?

I also want it to use custom standards for quote mark as inches and apastrophy as feet.

Matt