Converting Centimeter to Feet and Vise versa

StevenData · Apr 15th, 2002, 06:57 PM

Greeting,
In column A I have some values in Centimeter and would like to write a small macro to convert them to Feet (inches decimal). However I would like, when I apply the macro to the column A, the resulting converted values appear on Column B upon application so that I can see both values in CM in column A and their equivalent values in feet (inches decimal) in column B.
Your input is deeply appreciated.
Example of a value in cm: 243 cm
example of a resulting value in feet inches decimal: 7.4
Sincerely,
Steve

anno · Apr 15th, 2002, 07:23 PM

steve
you don't really need a macro for this but i'm sure someone can build one for you. you can use the CONVERT function instead. in cell B1 put =CONVERT(A1,"cm","in"). you'll need to install the analysis toolpak add-in (tools menu>addins) for this to work.

Yogi Anand · Apr 15th, 2002, 08:54 PM

Hi anno:

Just to elaborate, what you gave in your example "cm" and "in", Steven could go directly to feet by using "cm" and "ft"!
By the way that would be 7.97 ft -- I think Steve's reference to 7.4 must be in error
_________________
Yogi Anand
Edit: Deleted reference to inactive web site from signature line

[ This Message was edited by: Yogi Anand on 2003-01-19 18:19 ]

StevenData · Apr 20th, 2002, 03:04 PM

Thank you everyone for the feedbacks.
Sincerely,
Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 06:57 PM	#1
StevenData New Member Join Date: Mar 2002 Posts: 10	Greeting, In column A I have some values in Centimeter and would like to write a small macro to convert them to Feet (inches decimal). However I would like, when I apply the macro to the column A, the resulting converted values appear on Column B upon application so that I can see both values in CM in column A and their equivalent values in feet (inches decimal) in column B. Your input is deeply appreciated. Example of a value in cm: 243 cm example of a resulting value in feet inches decimal: 7.4 Sincerely, Steve

Apr 15th, 2002, 07:23 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	steve you don't really need a macro for this but i'm sure someone can build one for you. you can use the CONVERT function instead. in cell B1 put =CONVERT(A1,"cm","in"). you'll need to install the analysis toolpak add-in (tools menu>addins) for this to work.

Apr 15th, 2002, 08:54 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi anno: Just to elaborate, what you gave in your example "cm" and "in", Steven could go directly to feet by using "cm" and "ft"! By the way that would be 7.97 ft -- I think Steve's reference to 7.4 must be in error _________________ Yogi Anand Edit: Deleted reference to inactive web site from signature line [ This Message was edited by: Yogi Anand on 2003-01-19 18:19 ]

Apr 20th, 2002, 03:04 PM	#4
StevenData New Member Join Date: Mar 2002 Posts: 10	Thank you everyone for the feedbacks. Sincerely, Steve