ExcelBanter - is there a macro that will convert from inches to feet and inches

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - is there a macro that will convert from inches to feet and inches (https://www.excelbanter.com/excel-discussion-misc-queries/31531-there-macro-will-convert-inches-feet-inches.html)

cable guy

is there a macro that will convert from inches to feet and inches

I need to work and calculate in feet and inches, sometimes converting from
inches to feet and inches and back again. Is there any function or macro I
could use to accomplish this??

Duke Carey

Be sure the Analysis Toolpak is installed (ToolsAdd-ins), then look up the
CONVERT() funtion in the help file

"cable guy" wrote:

I need to work and calculate in feet and inches, sometimes converting from
inches to feet and inches and back again. Is there any function or macro I
could use to accomplish this??

All times are GMT +1. The time now is 06:40 PM.