Jump to content

How to format "number to engineer string"

Recommended Posts

I need to display the engineer string in a tree so I used number to engineer string. 

The issue is it is very limited to format the engineer string with this function. Look at below example


I want only one digit number before the decimal point but I don't know how to set that. Please let me know how to do it.

Thank you in advance.


Link to post

Aren't engineering strings always multiples of 3 digits? You cannot have an engineering string 1.2x10E10,it will be 12x10E9

Maybe I misunderstood the question.

if you want advanced string formatting you can use the format to string function, it allows a very flexible formatting string.

Sorry on mobile now or would put some pics.

Link to post
2 hours ago, Thang Nguyen said:

I want 1.2ex10 not 12.0ex9 as you can see in my example. I will check format into string.

Yes but that is no longer Engineering formatting which is where the confusion is coming in.

Format into string should be able to give you what you want, I will put an example shortly.


Link to post

Is this what you want? I still don't really understand the subtleties of all the different scientific vs floating point formats and normally just play around until I get what I want.

I find going into the Advanced numeric formatting is a huge help as it basically tells you the exact formatting string to use. Especially useful for timestamps!


Edited by Neil Pate
  • Thanks 1
Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.