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


    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
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?