1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel Engineering Units Formatter

  1. Oct 26, 2005 #1

    FredGarvin

    User Avatar
    Science Advisor

    There was a write up in Design News about a nice little Excel macro that will convert the tiresome Excel engineering units of xxxExxx or even .xxxxxx and xxx.xxxxxxx to the more readable x10³ type of format.

    The only drawback to this macro is that its output is text, not a number. However, it will be nice once you are done crunching numbers, you can put it into a format that will be easily readable for output to say Word or Powerpoint or just keep it in Excel. I think it's a nice tool to have.

    The article and link for the macro can be found here:
    http://www.designnews.com/article/ca6262833.html [Broken]
     
    Last edited by a moderator: May 2, 2017
  2. jcsd
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?
Draft saved Draft deleted



Similar Discussions: Excel Engineering Units Formatter
  1. Is there engineering (Replies: 8)

Loading...