| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can anyone show me how to set up Excel for feet and inches?
I do a lot of my spreadsheet work using the feet and inches, for the
construction industry. Does anyone know of an easy way to set or format the cells to deal with this? |
|
#2
|
|||
|
|||
|
There is not an easy way since those measurements are not very logical, this
might however be of interest http://www.mvps.org/dmcritchie/excel....htm#carpentry Regards, Peo Sjoblom "MarcoPolo" wrote: I do a lot of my spreadsheet work using the feet and inches, for the construction industry. Does anyone know of an easy way to set or format the cells to deal with this? |
|
#3
|
|||
|
|||
|
I guess I didn't realize just how difficult it would be. I just need to be
able to present a format and sort it accordingly without making a big deal out of it. right now I need to use multiple columns. Guess that the best I can do. "Peo Sjoblom" wrote: There is not an easy way since those measurements are not very logical, this might however be of interest http://www.mvps.org/dmcritchie/excel....htm#carpentry Regards, Peo Sjoblom "MarcoPolo" wrote: I do a lot of my spreadsheet work using the feet and inches, for the construction industry. Does anyone know of an easy way to set or format the cells to deal with this? |
|
#4
|
|||
|
|||
|
muliple columns are best esp if you use feet inches and fractions of an
inch...the dollarde and dollarfr work ok if you use only two of the three units.Another way is to do all calcs in inches and fractions and convert back to feet etc at the end -- paul remove nospam for email addy! "MarcoPolo" wrote: I guess I didn't realize just how difficult it would be. I just need to be able to present a format and sort it accordingly without making a big deal out of it. right now I need to use multiple columns. Guess that the best I can do. "Peo Sjoblom" wrote: There is not an easy way since those measurements are not very logical, this might however be of interest http://www.mvps.org/dmcritchie/excel....htm#carpentry Regards, Peo Sjoblom "MarcoPolo" wrote: I do a lot of my spreadsheet work using the feet and inches, for the construction industry. Does anyone know of an easy way to set or format the cells to deal with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel should show 4 dimensional charts | Charts and Charting in Excel | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I show excel worksheets on a webpage when viewed by win98 . | Excel Discussion (Misc queries) | |||
| How do I set my Excel Chart to not show areas where I have no dat. | Charts and Charting in Excel | |||
Hybrid Mode
