Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Engineering Notation Take Two

Engineering Notation Take Two

Engineering Notation Take Two

thread770-441692: Formatting engineering notation in excel

I recently decided to return to my hobby building and wanted to see things in Engineering Notation, so I dug out an old xla I had written.

I placed it in C:\Program Files (x86)\Microsoft Office\root\Office16\Library\Analysis

I had to update the links which was a google search.

I also found the following link if you want to do it yourself: https://excelribbon.tips.net/T012874_Engineering_C...

Mine has a lot more in it, including some programmer extensions. I don't know if the newer 64bit Excel obviates the need for some of them.

The password for my file is: juggernaut

There are a couple of issues I haven't taken the time to address, hey, it works for me.

This is in addition to not being able to hide the macro inside the entry cell, drats!

If you use the formula entry form for the "to engr" the StrForm must be in quotes. The Units seesm to work properly. "P" for power, "S" for shortform (M, T, a etc.) "L" for long form (Mega, Tera, atto etc.)

If any of you are real Excel add-in experts feel free to improve and share.

I still don't know why M$ hasn't done this themselves???

Mike Sr. btw: I stay off my work computer unless I have no choice. mike_a_sr@protonmail.com will get much quicker replies. :)

RE: Engineering Notation Take Two

Thanks for posting that Michael.

You might like a look at my Units4Excel spreadsheet.

It might be an idea to save the file as .xlsb or .xlsm, which makes it easier for people to access it, then they can save as .xla if they want.

As for why MS haven't done it themselves, they still seem to be under the misapprehension that people only use spreadsheets for numbers with a $ on the front.

Doug Jenkins
Interactive Design Services

RE: Engineering Notation Take Two

Geesh. I have a spreadsheet entirely populated by a VBA routine that has myriad cells populated with data in range about 4 times the size. Huge. Not a friggen cell with a currency value. No reason to assume some financial aspect to the sheet.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close