Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Converting Centimeter to Feet and Vise versa

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you everyone for the feedbacks.
    Sincerely,
    Steve

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •